victorsales
Registered User.
- Local time
- Yesterday, 17:28
- Joined
- Aug 2, 2013
- Messages
- 14
Hi All,
I have recently started using Access in order to create some standard in the way we keep our records and to move several different excel files into a single database.
So I started with the headings on the 2 spreadsheets we use: Supplier + Product Information and then applied the normalisation. I indentified all the relationships, created extra tables to manage many-to-many relationships and once finished I end up with 13 tables.
I was quite happy with the result and decided it was the time to start building the 2 only forms that I want people to be filling in (adding of course all the sub forms).
Here is the problem:
When I try to input a record on the supplier table I get the following error:
“Cannot add record(s); joint key of table “SupplierInfo” not in recordset”
And when I try to input a record on the “Product Table” I get the following error: “The value cannot be added to this new row until the row has been committed. Commit the row first, and then try adding the value."

None of the fields in both forms work they all show the same error. :banghead: :banghead: :banghead:
Considering I’m new to Access could someone point me on the right direction?
I can send a copy of the database if requested.
Thanks,
[FONT="]Victor[/FONT]
I have recently started using Access in order to create some standard in the way we keep our records and to move several different excel files into a single database.
So I started with the headings on the 2 spreadsheets we use: Supplier + Product Information and then applied the normalisation. I indentified all the relationships, created extra tables to manage many-to-many relationships and once finished I end up with 13 tables.
I was quite happy with the result and decided it was the time to start building the 2 only forms that I want people to be filling in (adding of course all the sub forms).
Here is the problem:
When I try to input a record on the supplier table I get the following error:
“Cannot add record(s); joint key of table “SupplierInfo” not in recordset”

And when I try to input a record on the “Product Table” I get the following error: “The value cannot be added to this new row until the row has been committed. Commit the row first, and then try adding the value."

None of the fields in both forms work they all show the same error. :banghead: :banghead: :banghead:
Considering I’m new to Access could someone point me on the right direction?
I can send a copy of the database if requested.
Thanks,
[FONT="]Victor[/FONT]