Mike Hughes
Registered User.
- Local time
- Today, 15:39
- Joined
- Mar 23, 2002
- Messages
- 493
I have a form (case information) which has two sub-forms. I want to add a third sub-form.
The form and the two sub-forms are linked by an audit id number
The third sub-form also contains the audit id number.
This form contains the worker names assigned to each case. (Sometimes one and other times 4-5 worker names) When I select a record on the form I want only the worker names associated with that case to appear, but what is happening is all the names in the DB are appearing. This third form is in the Datasheet view. Is there a way to make only the worker names associated with the case to appear?
Thanks
The form and the two sub-forms are linked by an audit id number
The third sub-form also contains the audit id number.
This form contains the worker names assigned to each case. (Sometimes one and other times 4-5 worker names) When I select a record on the form I want only the worker names associated with that case to appear, but what is happening is all the names in the DB are appearing. This third form is in the Datasheet view. Is there a way to make only the worker names associated with the case to appear?
Thanks
