Userid inserts into different user table fields
On my admin form (only for admins) I have a dropdown where I select user type.
(besides all the normal user stuff information)
If I I chose ""dealer" I need to capture userID (of the user I`m about to create) and insert that id into the users "dealerID" field
If I chose "salesperson" I need to capture userID (of the user I`m about to create) and insert that id into the users "salespersonID" field
So my question is:
How do I capture the id of the user I`m about to create ?
How do I on "Insert" tell the system, that if I selected dealer it should insert the id into the dealer field of users table
and if I select salespersion, it should insert the id into salesperson instead ?
best regards
Bison