I have a from the has two sub-form tables that share StudyID in link child and link master. The form works perfectly. But the information stored in the tables is creating problem when I need to create a report off of that information.
I have a query that runs off of three tables. Each have their own unique ID such as EntryID and Entry2ID and the main ID is StudyID. All three tables share the the main table StudyID. Since the information is coming from the form which keeps a history and in the query I have to use the last set of information. In the total I entered Last which works if I only link two tables. When I link the three tables is where I have the problem. It will pull the unique Entry2ID with information from a different record set to include with the other table information.
I hope I explained it correctly.