Insert query please help

[knowledge76]

Hi all,
I am little bit confused how to solve my problem at the moment. I have spent a couple of days on it but came never close to solution.
I have a table A which contains the order list of husband and table B which contains the order list of wife and I have a table C which contains the information about husband and wife like first name and last name. Now sometime husband does not order anything in a month but wife does and other way around. How can I insert the values of husband and wife from Table A and Table B into table C.


please have a look at the table.

 

[Starman]

Without looking at your db, it sounds like you have some normalization issues. Orders should be in a separate table with a foreign key to the person who ordered it. You can have a subform to display the person's orders on your main person form to more easily read the data.

 

[knowledge76]

Can you tell me how to do this as I have tried in your direction as well but was not able to solve it.

 

[Starman]

When you are looking at your form in design view, one of the options on your toolbar should be for a subform. Select it and draw on your form where you would like it to appear. Then a handy wizard will walk you through the steps of picking the table or query you want to get the subform's data from and how it should relate to the main form.