Hi,

I am making a database for a study where different tables will be completed (by filling in forms) at different times in the study for the same participant.
I would like to create a checklist table that automatically lets the user know which table they have filled in for each participantID (which is a field common to all the tables of interest) so they can monitor their progress.
The participantID will initially be entered into a table called PersonalDetails, I then need to know whether the same participant has been entered into
> PersonalDetailsConfidential
> GPRecordInformation
> GPRecordInformation2yrs
> PASDetails
> PASDetails2yrs

I have tried doing this with a query, but it will only put a participantID in the query if every table has been completed for that participant, which is obviously not the point.

I would be grateful for any suggestions on how to do this


THANKS

You are using an inner join in your query. This is the default join in Access and it requires matching data on both sides of the join to return any results. If you change the join type by right clicking the join in design view, you can see the effect of changing it to a left (type 2) or a right (type 3) join.

I wonder about your structure. Different tables for different interests counds like the wrong way to do it.

Thanks - that's worked perfectly