Hi Edward,

Thanks for providing the images. If you're trying to do what is in screenshot two, you could just create the following query in the schema browser within the study schema:

SELECT table2.id,
table2.Med_No,
table2.Name,
table2.Time,
table2.Quantity,
table1.Name AS Table1Name,
table1.Age,
table1.Sex
FROM table2
JOIN table1 ON table2.id = table1.id

But if you're trying to use the fields that are nested within the grid view, these rely on the combination of the participant Id number and the specific visit value together.

Regards,

Jon