query problems

[meekychunky2004]

Hi

I need to create an order form with info from several tables. The first table being the customer info, the second table is orders and the third table is orderlines.

I want to be able to select the customer then enter an order with several orderlines from combo/list box but am getting error messages saying cant update field.

What is the best way to do this?

 

[dcx693]

Can you post your table structure here?

 

[meekychunky2004]

Hi and thanks, I have listed the table structures below. At the moment the relationships for the orderline table are connected to other tables; language, type, and readership .... is this the right way to do this?

Table: Borrowers
BorrowerID
BorrowerName
Company

Table: Orders
OrderID
BorrowerID
BorrowerOrderNo
OrderLineID

Table: OrderLine
OrderLineID
Language (selected from Language table: French/ German)
Type (selected from Type table: Fiction/ Non-Fiction)
Readership (selected from Readership table: Adult/ Junior)
Quantity
TotalQuantity