E
Edward Jones (Eddie)
I have a table of items with a primary key of item number. In all other table
items are referenced by their item number. I want to have a form to add a
record to a new table that will have a field for item number that is filled
in based on a users choice of item from a drop down list of the items name. I
have a drop down of all the item names but how do i ensure that the item
number is written to the new table. And vice versa how do i have a form for
the new table that shows records with the items name not just the number. If
possible i would like the form to avoid having a subform. Thank you.
items are referenced by their item number. I want to have a form to add a
record to a new table that will have a field for item number that is filled
in based on a users choice of item from a drop down list of the items name. I
have a drop down of all the item names but how do i ensure that the item
number is written to the new table. And vice versa how do i have a form for
the new table that shows records with the items name not just the number. If
possible i would like the form to avoid having a subform. Thank you.