Subform issues

[dark11984]

Hi I am building a form to be used for ordering. the main form contains a subform that I am having trouble with.

On the main form I have my employee information - name, branch, department. On the subform I have the product info - prod code, description, price, qty, etc.

The control source for all the data from both the main form and the subform is set to my order table.

I have two problems. The first is one is that if i type multiple products onto the subform they all show up in the order table but the employee details only appear for the first record (first product). I need them to appear next to each product in the table.

My second problem is I am having trouble linking the subform to the main form - no common data. so when I move between records on the main form the subform data does not change.

Sorry for writing a novel but I wanted to make sure I explain everything the first time.

Thanks.

 

[RuralGuy]

It sounds like you might have a normalization issue. Your Order should be in an Order table with an AutoNumber (OrderNo) PrimaryKey field and a CustomerID as a ForeignKey from the Customer table where all of the specific customer information resides.