I want to allow one type of user to add/modify using a form with 20 unhidden fields, and another type of user to add/modify using a form with 5 of the original 20 fields unhidden, and 15 of the original fields hidden.
I also want both users' records to show up on the same search results page.
Is it possible to have 2 add_forms, and 2 modify_forms, using only one database? Or, is there a way to have DBMan search two databases and display the results on the same page?
Also, when it comes to modifying, I want to allow users access to only their respective modify_forms. Is there anyway for DBMan to determine the type of user at log in, and send the user to the appropriate modify_form?
Thanks again for your help.
Rick
I also want both users' records to show up on the same search results page.
Is it possible to have 2 add_forms, and 2 modify_forms, using only one database? Or, is there a way to have DBMan search two databases and display the results on the same page?
Also, when it comes to modifying, I want to allow users access to only their respective modify_forms. Is there anyway for DBMan to determine the type of user at log in, and send the user to the appropriate modify_form?
Thanks again for your help.
Rick