Form - Customer Number Unique entry

[Kully121]

Hi,

I've designed a form and would like to add a field [Customer Number] in which only needs to be entered once.

However i have a number of products/prices that i need to enter on the same form.

How can i assign the customer number against all products

So that my my final table will have the following

Customer Number , Product, Price

 

[Andrew Fergus]

Hi
Have you looked at using a form / subform arrangement? The master information (i.e. customer) would be entered into the mainform and the detail information would be entered into the subform (products and prices). I believe that such a form would give you what you want.
HTH, Andrew.