I am trying to do a query and it is not working out right. I have 4 tables. 2 tables hold static data for the user to select from on the form. I want to split this data and instead of it writing to one table which it is now. I want it to write to 2 different tables. 1 from one table and one from the other. So two tables as control source and 2 tables as Row source. I have tried to do this in a query but it's not right. I think I may be doing my Relationships wrong. Can someone help?