Form problem - not updating and missing ecordset

[JustSara]

My database is in zip format here: http://www.sweeperhead.com/database.htm

This is my first database. I've created a form with a subform in it but some of my fields are saying that they can't update and some of them are saying something about a missing link in a recordset. I've searched through my book and the internet and I'm completely stumped. Any help would be much appreciated.

I'm trying to create a database of all my customers, what they purchased, how much it cost, and when they bought it. Most customers purchase more then one item so I've created a Products subform so I can list multiple item. It's just not working.

Please remember that I'm very, very new at this so reply using small words if at all possible.

 

[jfgambit]

Attached is a changed database. I updated your relationships and changed the underlining query for the subform. The way you have your table structures you cannot pull information from two separate tables without updating all the necessary information (primary keys) in those tables.

I also converted some of the fields to be drop down comboboxes to select the necessary information from the joined tables.

Let me know if you have any questions.

 

[JustSara]

Thank you for helping me. I do still have a problem. When I'm inputting data into my Form I'm getting a 'cannot add record; join key of table 'tblInvoice' not in recordset.' but I only get that error message on record 2 fields. Record 1 fields seem to be fine.

Also, while it is adding the information to the tables. Once I close out of the Form and open it back up it will only show the first record. I could have input 10 names - and 10 names will be in my table - but my Form will only say 'showing 1 of 1 record.'

Sara

 

[jfgambit]

Sara:
Are you getting that on the database I attached to the previous post? I just tried to enter data in that one and everything was ok. I will post it again.

 

[JustSara]

Yeah... when I open the form to input data the first record is accepting the information just fine. But when I click to go to record 2 and try to input the date I get that recordset error message. Are you able to enter the date on the second record?