Why do you store the Relative ID in the table instead of the Relative name? I have watched your videos on Combo boxes. You stored the state names in the customer table and not an ID. I understand there are only 50 states, but there are also only so many relative names as well, so I was thinking that cannot be the reason you use the ID instead of the actual name.
Reply from Richard Rost:
As a rule of thumb, it is better to store IDs in a table as a foreign key instead of names. Why? That could take me 20 minutes to explain, and I'm pretty sure I covered it thoroughly in Expert 1.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.
