I have an ACCESS 2013 application. The application has a one to many relationship between the Job table (tblJob) and JobVenues table (tblJobVenues).
tblJob has the following fields:
JobID (Primary Key - Auto Generate)
tblJobVenues has the following fields:
JobVenueID (Primary Key - Auto Generate)
JobID (Foreign Key that links it to tblJob)
I want my form to display the Job information, with it's related venues in a some sort of grid.
How do I do this? Do I use a sub form, a form in Datasheet View, or something else?
I have attached a sample of what I want to accomplish to this post. Thanks in advance.
I tried the following code and it failed: