I have a 15 LookUp Tables tied to 15 ComboBoxes.
Some of the Tables contain 3 to 10 Recs, and a couple contain up to 50
Recs.
1- Is it a CommonPractice to link the field that gets the ComboBox
result, to the Lookup Table to ensure Referential Integrity and
Cascaded Updates?
2- Also, should the LookupTable PrimaryKey be an AutoKey or the Name
of the main field being referenced, which in my case would average 15
chars, but in two cases be 50-chars long? The AutoKey would be
smaller, but given the size of the Tables may not be necessary?
3- Should I store AutoKey value, or the Value of the main field being
referenced?
Thanks
Greg
eld or is the MainField sufficient as the Primary since each will be
unique, BUT may be up to 50 characters long in a few instances??
2- Should each LookUp Table be linked back to the maintable at the
ComboBox