some extra help needed please
I would have to use this option quoted as not all users are staff members. I would also like to apply security assist, and this option is similar to the blue sky music security assist authenticate user tutorials so it will make it easier for me.
What i was thinking to do is to make sure that a person is in the people table before they are inserted into the staff table. The problem is how do I call the personID. In the data assist wizard, do i use a menu or a textfield. A textfield will allow the inputter to just input the ID number manually. Is this the right way to go?
Alternatively if I set the personID to a drop down menu during data assist wizard on the insert/ update page, when the inputter selects the id number from the drop down could I have a firstname and lastname textfield autopopulate (from people table) based on the id?
Finally if both are possible I would like to combine the two ideas by giving the inputter the option to choose the id number from a dynamic menu, or type the number in a textfield. Then if the Id exists it will auto-populate a firstname and lastname text field, just so the user in definately sure they have input the right personid number.
Sorry for the length of this comment, you may have an easier option for all of this.
Your help is much appreciated