OK I have a Personnel database with a personnel form that has all the fields in it.
I want to create an Injuries form where you just select/type an employees name and then add injuries data to an injuries table (linked to the persons ID number in the Personnel database).
What is the best way to select the persons name?
I only want to be able to choose from current employees.
I have seen a form where the name is at the top and not editable and then there is a sub-form with the editable data. Is that a good method?
If so how do I make the main form not editable but the subform editable?
Ideally I would like to start typing the persons name and have a list come up showing employees whose name starts with what has been typed.
I want to create an Injuries form where you just select/type an employees name and then add injuries data to an injuries table (linked to the persons ID number in the Personnel database).
What is the best way to select the persons name?
I only want to be able to choose from current employees.
I have seen a form where the name is at the top and not editable and then there is a sub-form with the editable data. Is that a good method?
If so how do I make the main form not editable but the subform editable?
Ideally I would like to start typing the persons name and have a list come up showing employees whose name starts with what has been typed.