I'm not that familiar with Access databases and need a little help with an application I am putting together. I have 2 tables in an Access database that are related by a unique key (an associate badge number).
I want to create a frame on the top of the form that displays the employee information (1 table). On the bottom of the form, I want to display the information that is located in another table (specifically vehicle information). Each associate can have more than one vehicle registered, so I want to display all of the related records.
Not sure how to proceed. I've tried to create a data environment and drag the fields to the form, but when I move to the next record the data from the other tables aren't being updated on the form. Any help would be greatly appreciated...
I want to create a frame on the top of the form that displays the employee information (1 table). On the bottom of the form, I want to display the information that is located in another table (specifically vehicle information). Each associate can have more than one vehicle registered, so I want to display all of the related records.
Not sure how to proceed. I've tried to create a data environment and drag the fields to the form, but when I move to the next record the data from the other tables aren't being updated on the form. Any help would be greatly appreciated...
