I am attempting to create a linked database from two distinct messy databases of which neither have primary keys.
So, I'm creating a new Master ID field which links Patron ID and Donor ID. There can be multiple patrons and multiple donors per master ID.
There could be an instance where I'd like to delete or modify the Master ID because of discovering there is redundancy between different records in my new linkage table. Unfortunately, the data I'm working with is too messy to get it all right the first time around.
Is it possible to modify keys as long as I'm modifying the values in all the tables in my Relationship? If not, I guess I could just build a flat database with no key but then I guess I'd be building a POS DB.