Storing Data from Combo Boxes

[ahuvas]

I know this is probably a basic question but I just need to clarify something.

I created a combo box using a wizard in a form that relies on its options by looking up data from a spefic table (Y) i.e. such as employee role. So far so good.

However when I create the field in the table in which the user response is stored in Table X, and I am specifying all the details in the general and lookup tab,

Do I:

A. store the data as text or
B. do I go to lookup tab --> display control --> combobox etc..?

 

[wazz]

...Do I:
A. store the data as text or
B. do I go to lookup tab --> display control --> combobox etc..?

you should be storing, as per your example, the EmployeeRoleID (the ID not the 'text' or 'description'). so you should be storing a number (long int). don't go to lookup tab and change things there.

 

[ahuvas]

Thank you Wazz. What is the role of the look-up--> combo box etc? When is this used?