Hi, I'm creating a database of the transactions of items made by the employees. There's two tables in this database. In one of the tables, there's two fields, them being the available item names(ITEM DESCRIPTION) and the respective codes for each item. The primary key for this table is the (ITEM CODE) The next table, which is mainly for data entry shows the name of the employees, the quantity of the item requested and the ITEM CODE. Both these tables are linked thru the ITEM CODE. My question is, if in the FORM format, how can i link the ITEM CODE and ITEM DESCRIPTION together. Like for example, i would like to have the field under ITEM DESCRIPTION appear automatically when i enter the ITEM CODE field in form.

Have you considered creating a query using both tables then creating a form based on fields selected form this query.

Hi johnt, I've already done that. But it seems that when i'm doing data entry in Forms, i can't get the ITEM DESCRIPTION to appear automatically when i key in the ITEM CODE. How, any help?

Create a combo box based on your ItemDescription table. Set auto expand on and store the ItemDescription in your Employees table. This will then reference the ItemDescription for display in other forms. The ItemDescription can be viewed in the combo drop-down if the combo box is set for two columns.