- Local time
- Today, 05:51
- Joined
- Feb 19, 2002
- Messages
- 42,981
It's not an orphan table. It is a definition table. It contains the universe of records that are to be added. So the table would have two columns
ScoreTypeID
TypeDesc
Your query would only append the ScoreTypeID. The description would be shown on the form if you want it to be via a join to this table on the ID field. One additional advantage is if you need to add a 12th type. No code needs to change nor do any forms, queries, or reports. You just add type 12 with its description to this table.
ScoreTypeID
TypeDesc
Your query would only append the ScoreTypeID. The description would be shown on the form if you want it to be via a join to this table on the ID field. One additional advantage is if you need to add a 12th type. No code needs to change nor do any forms, queries, or reports. You just add type 12 with its description to this table.