Microsoft JET Database Engine error

[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

 

[Douglas J. Steele]

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.

 

[Jerry Martin]

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)






.