Cant input enter data into mutiple table form

[MadRueNRG]

Hello all,

This is my situ.
I have a database with 3 tables. The first is the customer details table that stores customer details and the customer ID key field. The second is the order details table which stores the order details such as the P&P and the courier, this table has the Order ID key field. The third table is the order line table, this table includes specific details such as quantity and product title. This table has the Order ID foriegn key field.
I have a form that displays the customer details and allows the user to add and edit the records. This form also has the order details fields in it but I am unable to enter anything into these. Its as if they are locked but there not. It doesnt give me any erros, it just doesnt let me put anything in. I set up the form with the wizard because i dont know how to link forms, i let the wizard do all that.
The other problem i have is I cant get the combo box to view the product title from the Order Line table. This combo box is in a sub form that displays as a datasheet. I also need it to display the unit price for that product when it is selected from the combo box.

Please could you help me with this problem. Thank-you very much

Rue

 

[a.sinatra]

Alright, the only suggestion i have is to setup the checkboxes so that only one can be checked, because i doubt your going to send the same package for two methods.
________
HONDA FSC600

 

[MadRueNRG]

Thanks for the help

Thanks for that, i understand what you mean. I have now solved the original problem with some help from a friend of mine.
I now have another problem, lol, one after the other.
With the same database as described above, I now have a problem of not being able to select products. I have made a form with the customer details, in that i have a sub form with the order details which work fine, in that sub form i have a sub form with the order line details. I want the user to be able to select a product from a list from the order line table through a combo box in that sub form. I want the form to display what products are for that order. For some reason it is trying to add records and not select them. I also need the unit price to be related to the product title when it is selected. You can understand what I mean by looking at the database attached to this reply.
Would I need 1 form to add and edit and another form just to view records?

Im totaly lost here.

Thanks for all help.

Rue