The database I'm developing for a local charity has a table with detail
records of individual transactions with our donors. This table has an
integer "donorID" column that is a foreign key to a "donor" table
containing names, addresses, etc. The data entry people use a custom form
to enter new transactions into the detail table.
Occasionally incorrect data gets entered, so I also want to provide the
data entry folks with a convenient way to amend a detail record.
Specifically, we need the ability to amend *any* field in a record,
including the donorID. And to amend the donorID, the database must
present it to the user in terms of the donor's name and address, not the
user-unfriendly numerical ID itself.
This sounds like such a common requirement in Access database design that
there's a best practice for it. Can anyone help?
Thanks
Rick