Use a field from another form in a table

[phroureo]

I have two tables.



One is "Inventory Items." Fields are InvItemID (PK), Item Name, Part Number, Vendor, and Price.

Two is "Inventory Transaction." Fields are InvTransID (PK), InvItemID (FK), and Number Ordered.

I have a form that will add items to the "Inventory Items" table.

I want to create a form that will add a record to the "Inventory Transaction" table. However, I want to be able to add the items based on the Item Name from the "Inventory Items" table, and not have to remember the InvItemID for each thing.

How would I go about doing this?

EDIT:Never mind! I figured it out. I used a combo box to request the info from the Item Name field, and then stored it in the InvItemID field.

[Missinglinq]

You're describing the classic Main Form (Inventory Items)/Subform (Inventory Transaction) scenario. Your InvItemID Field would be used in the LinkMasterField/LinkChildField Properties of the Subform Control.

After entering or selecting the appropriate Record from the Main Form (Inventory Items) you'd enter a Record or Records in the Subform (Inventory Transaction) and the Access Gnomes would automatically populate the InvItemID Field in the Subform with the InvItemID Field from the Main Form.

Linq ;0)>