Advice needed re: who registered Who?
Hi Guys,
Please could you tell me if this is possible and maybe some directions on completing this.
In my database I have two administrators that will register new users. In this example let's say the administrators are Company A and Company B respectfully.
When Company A registers a new user a prefix of say CompA is written to the users ID (CompA101) and CompB would become (CompB102) I understand that the numbers will be incremental only the prefix will change depending on who registers the user. I would be looking to have two admin registration forms, one for Company A and one for Company B.
When a new user logs in I can then do a look up and display details for Company A or B respectfully.
Or would I need to create a new data base table such as instead of adding a prefix
CompanyID
AdminUserID
AdminCompanyUserID
And then make a many to many relationship instead of writing a prefix to the users ID?
Thank you in advance for your time in this matter.
Kind regards
Jonathon