jk wrote:
> Hello,
>
> I tried joan wilds great suggestion on splitting the data base
> manually and installed it this morning into a network folder.The copy
> went into this folder deleting everthing except the tables.The other
> copy went on my desktop and one more user...no security since this
> was just a test.I linked the tables and data was being keyed in with
> no problem untill about ten minutes ago...i get the message.."you can
> not add or change a record due to a releated record is required".The
> desktop copy shows no links in the relationship view but the link
> symbol looks the same...a big arrow towards the tables.Could the
> network boys run a program that would break the links????
The message has nothing to do with the links. It means that you are either
1. trying to add a record to a child table, and there is no related parent -
eg. creating an order for a customer that doesn't exist.
2. trying to change the foreign key field value in a child table, and the
new value doesn't exist in the parent - eg. changing the customer on an
existing order, and the new customer doesn't exist.
--
Joan Wild
Microsoft Access MVP
|
Similar Threads
