I've heard and read over and over lookups are bad on tables. I'm still confused on the appropriate usage.
I've attached a sample db here of my current db with 4 tables.
tblAirlineTransactions - contains lookups for the three tables below.
tblAirlines
tblFuelProviders
tblIssueTypes
I've also included a sample form with another lookup. My reasoning is, when users enter any data, I like to verify they are only able to choose any Airline, FuelProvider, etc that has an Active status.
If this is not the correct way, can someone please elaborate or change my sample so I can understand?
Thanks!
I've attached a sample db here of my current db with 4 tables.
tblAirlineTransactions - contains lookups for the three tables below.
tblAirlines
tblFuelProviders
tblIssueTypes
I've also included a sample form with another lookup. My reasoning is, when users enter any data, I like to verify they are only able to choose any Airline, FuelProvider, etc that has an Active status.
If this is not the correct way, can someone please elaborate or change my sample so I can understand?
Thanks!