Can anybody tell me if the following can be done, it's a somewhat recursive scenario:
1) There's a "Donor Table" in the database, each record consisting of a key, name and address usual info and a reference to another contact. That contact should be another/different entry in the same table. Can Access be configured to use the same table for which a new record is being added to verify the validity of another entry in that table?
For example, the XYZ Foundation has been an annual donor to a charity. The person to directly contact for XYZ Foundation is John Doe, is it possible to fill in the "Contact" data field for XYZ Foundation with the key identifying John Doe and have Access use the same Donor Table to verify John Doe's key?
---- Holland's Person, Bill- The early bird may get the worm, but the second mouse gets the cheese!
__________View the list's information and change your settings at //www.freelists.org/list/programmingblind