Yes it is a 1 to many, or 1 to 2 in my case, and I have been thinking that I would have to use 2 subforms on the main form. If I didn't have 3 tables and only 1 with all the fields on, then it works ok without subforms.
Thanks
I sort of solved this problem by using 3 separate tables, 3 separate queries and 3 separate forms. I then put 2 forms on a main form, which does what I want. Its not exactly how I wanted it but if that is the only way, it'll have to be.
