Fill in the same order number

[canett]

I have a continous form where the first control is orderid.It is based on a query.I want however to add other orders.I can do it, if choose another product from the combo box and write down manually the same order number as the previous ones.Can i do it by a code?
For example the first line in my form reads
orderid product
1 productOne
If i choose ProductTwofrom the combo box, the control OrderID remains blank.I have to write down the number 1 and then Access accepts my edit.
Can somebody help me ?

 

[ZmrAbdulla]

You should have a master-detail form structute to do that. connect them with orderID. See northwind sample db for more info

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[TheAceMan1]

How are ya canett . . .

Be sure you fully understand the following and you'll save yourself alot of trouble:

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

See Ya! . . . . . .