Here is my very rough Taxi/Messenger application design. Feedback sought.
When I enter trips on my TripControlForm, I need to save a permanent record of the addresses (or address keys) for those specific trips. I’m not sure where those keys should be stored—in the Address table or TripControlTable.
In my ClientInfo table I used a table level Lookup field with my address table as the source. This actually worked but: The address values—or keys to those values—are not actually stored anywhere. They’re transient. So If I query the client’s name for a trip on a certain day, address data shown will be whatever her address is at query time and not what it was on the day of her trip (if they’re in fact different).
Bear in mind that many of the fields will be either eliminated or switched to different tables in a later configuration.
This will all make more sense once you take a peek at this copy.