Microsoft JET Database Engine error

  • Thread starter Thread starter Jerry Martin
  • Start date Start date
J

Jerry Martin

I get this message in a Dialog window, "You cannot add or
change a record because a related record is required in
table 'TRANSACTIONS.'

Anyone ever seen this or know which way to go to resolve
it?
Thanks, Jerry
 
It implies you've set up a relationship to enforce referential integrity
between table Transactions and whatever table it is you're trying to update,
and the record you're trying to add (or change) in that second table is
pointing to a record that doesn't exist in the Transactions table.

Think of invoices: you might have an Invoice table that contains the details
as to who the customer is, the invoice date and so on, linked to an Invoice
Detail table that contains one row for each item sold. You can't create an
Invoice Detail entry until you've created the Invoice entry.
 
Thanks Douglas, makes it a lot clearer.
-----Original Message-----
It implies you've set up a relationship to enforce referential integrity
between table Transactions and whatever table it is you're trying to update,
and the record you're trying to add (or change) in that second table is
pointing to a record that doesn't exist in the Transactions table.

Think of invoices: you might have an Invoice table that contains the details
as to who the customer is, the invoice date and so on, linked to an Invoice
Detail table that contains one row for each item sold. You can't create an
Invoice Detail entry until you've created the Invoice entry.



--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)






.
Click to expand...
 
Back
Top