Entering ID in the form and viewing n the table with its corresponding name

[Ghaznavi]

Hi,
I have made a table and I enter data in that table through a form. The form also include two sybchronized comboboxes. When I select a category in one combo box, corresponding items are selected in second combo box. The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?

Kindly help.....

 

[bob fitz]

.....The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?

Kindly help.....

That is not a problem, that is how it should work. The tables are not for viewing data. They are just for storing it. Use queries to retrieve the data and reports and forms for viewing the data (as you seem to be doing now).

 

[Ghaznavi]

That is not a problem, that is how it should work. The tables are not for viewing data. They are just for storing it. Use queries to retrieve the data and reports and forms for viewing the data (as you seem to be doing now).

The problem is that the data entry will be done on another computer, and I would frequently export that table to an excel sheet and copy that sheet to my computer (by usb, not networking) and it would be linked to my data base. In this case. kindly suggest, how to see the category name instead of ID.

 

[bob fitz]

Export the category table as well and link to that table too.

 

[Ghaznavi]

Export the category table as well and link to that table too.

Thanks...the problem is solved