Hi Alex, my question was basically - Should you turn all F.K. fields in a Table into Combo Boxes ? Since you might make those fields in 1 Table before realizing that they could be F.K.'s from other Tables, is there a low # of values the field should generally be able to hold when you should make it a Combo Box (vs. a Text field with some repeating values)? (Ex: Should CompanyName be a Combo Box?) Thanks!
Reply from Alex Hedley:
If you mean a Lookup Field in the Table then no. Keep it as a number. If you are going to reference these on another Form then yes a combo makes more sense as you can see their name instead of just 1.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.