Hi, I know this topic comes up a lot but each question is slightly different and the problems are also different in each. Currently my DB has a demographics table and Clinic1 table, I open a form that runs a query based on Clinic1 with results incorporated within it, I can type a UN (key) into the form for Clinic1 and it pulls the contents of the corresponding UN in the demographics table through (great). However, I've now separated the clinics contents and have managed to make a new form which works in a similar way but queries Clinic2 table and demographics table. My problem lies with getting afore mentioned results which are relevant on this form too from the form for Clinic1 onto Clinic2. I thought as long as my new query for Clinic2 form had the fields of the results from Clinic1 table in it, it would work in a similar way as the UN does between demographics and both the Clinic's forms... but it doesn't. I have tried setting up a new table with its own primary key etc based upon the UN which I related to the same UN in the demographics table... what I get is a purely blank form, no tabs, fields, buttons or anything. Essentially, I need to type a UN in and get the demographics and results pre-populated.
Many Thanks for your help if you're able.
