I recently changed my ways, switching to serial numbers as keys.
I may be missing something very basic, but, Is there a particular strategy for creating a new record in this situation:
I have a TABLE_A of info that is child to two different parent tables.
To create a new record in TABLE_A, I used to go to a list layout based on TABLE_A, create a new record, and then fill in manually the two text fields that connected TABLE_A to it's two parent tables. But when using Serial Numbers instead - How do I make it easy for the user to know what the serial numbers (the secondary keys in TABLE_A) are that connect it to the parent tables?