Recent content by Aye

I revise my tables as you suggested; only two tables with one to many relationship. Now Query really comes out with no duplicate. Thank you very much.

I'm also developing a database which is very similar to yours. I attach my tables and relationship which are largely one to many. Problem I come across is when I run the query using more than 2 tables, I get duplicate data particulary in terms of dates.(eg-Demographic table - Lab investigation...