Ok, so this is basic, but I am relatively new to access and have hit a roadblock. I have looked at a bunch of threads here but can't find anything that addresses my question, so I thought it easier to state it here.
I have a master table, Project Tracker, which has all the details of the individual projects I have going on stored in columns, nearly 200 different data points. I have created a form which displays all the information from this table, and have included some tabs/pages in this form to help spread the load across a number of different pages.
One page, "Lab Results" is different. I want this to display information from another table. This table has 11 columns, and could contain multiple results for a certain case. Each time lab results come in, they are entered into the Lab Results table.
What I want to do is display the information only for that record on my lab results page. They share a common "Job Number", the only informational link between the 2 tables.
I am sure this is really easy, but need help. Thanks!!!