Hi all,
I am doing an accounting assignment on access which requires a form with subform for an order which can have many products. The products are in the subform and in the main form I have the order #, customer details date salesperson etc etc. After alot of trouble trying to do the subform and getting it to total, I have now run into the problem of Cannot add record(s); join key of table ' orders' not in recordset. When I try to enter new data into my form!!
I have tried reading up on this with the relationship thing but I just don't get it and its really driving me NUTS
I'm no expert on access and I'm really frustrated now, I have tried looking at the northwind template which absolutely BLEW me away! it is so amazing ! I could never do that! I just want to be able to enter data into my form!
I have attached a word document which shows the relationships and the form which I am using. If anyone has any suggestions PLEASE advise!!