bcooper

I see how it would work. Unfortunately, that would force me to create a duplicate of every singe field in my database.

Is there any possible way to do this without Portals?

I see. Lots of 1 row filtered portals.

I guess I'm a bit confused. If I have a table called Contacts with the following information: UserID: 1 FirstName: Ben LastName: Hill --- UserID: 2 FirstName: Don LastName: Jones I can produce a record in another table called Sources that would then look like this: ID: 1 Field name: FirstName fk_RecordID: 1 Source: I found their first name by searching the employee database. --- ID: 2 Field name: LastName fk_RecordID: 1 Source: The last name was supplied by the employer. --- ID: 3 Field name: FirstName fk_RecordID: 2 Source: The source is yet unknown What still confuses me is how on a report to connect this information on a report. On the report it would need to look something like this: Field Value Source UserID 1 FirstName Ben I found their first name by searching the employee database. LastName Hill The last name was supplied by the employer. --- UserID 2 FirstName Don The source is yet unknown LastName Johnson

I understand the creation process to build the records in the table, but how do I get the data back out on a report? I will I be able to link back to the source that was entered? For instance, how can I get the report to list the source entered for First Name in the Employees table now that the source is stored in an unrelated table?

I am building a custom database for a law firm. I am rapidly approaching 60 tables, as it records everything you could possibly imagine related to plaintiffs, defendants, judges, courtrooms, filing dates, home addresses, business addresses, injuries, settlements, etc. I was about done with the database, when they added a new wrinkle. For every single field in the database, they want to record the source of where the data came from. (Where did the first name come from? Where did the last name come from? Where did the address come from?) They want to be able to interact with this information during data entry, as well as having it show up on reports. Short of adding an extra field for every piece of data in every table, does anyone have a good way to go about this? I’ve experimented with creating a script that is able to create unique values in an unrelated table for every source value while doing data entry (if it doesn’t already exist) using a custom dialog, but then I can’t figure out a way to get those values to show up again next to each field when doing reporting. Any help would be appreciated.