Hi,
I currently have one link table working successfully, based on 4 common fields in 3 tables, and a key generated by autonumber using those fields. I want to add another table to my app, but it has only 2 of the 4 common fields.What's the best way to go about this? I tried adding a second key, but that didn't seem to work. If I added a second link table, that would have to link to the first link table? I'm sure I'm missing a more efficient solution.
Many thanks.
