I'm new to access so I think I'm just not adding 2 and 2 together. I need to make a form that bases itself on at table. The records are already available in that table and I have no problem chosing the ones I need when I need them.
When I choose a record, I need to add an issue date and have it list in a subform. Choose, Date, List. Next record, Choose, Date, List. etc. When the issues are complete, all of the issued records should be saved using a form ID (I tried autonumber) so I can query what was issued on each form instance. 1 ID to many Issued records. Can someone guide me to the right information? I feel like I've been reading a dictionary and still not finding the word I'm searching for.
Thanks
When I choose a record, I need to add an issue date and have it list in a subform. Choose, Date, List. Next record, Choose, Date, List. etc. When the issues are complete, all of the issued records should be saved using a form ID (I tried autonumber) so I can query what was issued on each form instance. 1 ID to many Issued records. Can someone guide me to the right information? I feel like I've been reading a dictionary and still not finding the word I'm searching for.
Thanks