E
Eric
I am trying to do AutoLookup for the first time. I am
essentially dealing with two tables. One is called "Part
Numbers" and contains a list of unique part numbers for
items that could appear in our inventory and a description
of each part. The second table is called "Add" and is
filled in using a form that someone (like a receiving
clerk) would use when something has arrived and needs to
be "added" to the inventory. To minimize human error, I
want the "decription" field in the "add" form to
automatically fill itself in when someone types a part
number into the form by referencing the Part Numbers table.
Per the instructions in Access Help, I did the following:
I created a one-to-many relationship between the part
number field (the primary key) in the "part numbers" table
(the "one" side) and the part number field in the "add"
table (the "many" side). I set the description field in
the "part numbers" table to "Indexed (No Duplicates)" and
made sure the description field in the add table is not
indexed. I created a query with both tables and drew a
relationship in the query between the two part number
fields again (I left the Join Properties to whatever the
default is). I placed the Part Number field from the Add
table and the description field from the Part Numbers
table in the query design grid. I checked the box
indicating that both should appear, and saved the query.
When I type a part number in the add form, nothing
happens. So I either missed a step above, or a I did
something wrong. I've tried to put everything and the
kitchen sink in this post so hopefully someone will be
able to identify the issue right away.
Thanks for the help!
essentially dealing with two tables. One is called "Part
Numbers" and contains a list of unique part numbers for
items that could appear in our inventory and a description
of each part. The second table is called "Add" and is
filled in using a form that someone (like a receiving
clerk) would use when something has arrived and needs to
be "added" to the inventory. To minimize human error, I
want the "decription" field in the "add" form to
automatically fill itself in when someone types a part
number into the form by referencing the Part Numbers table.
Per the instructions in Access Help, I did the following:
I created a one-to-many relationship between the part
number field (the primary key) in the "part numbers" table
(the "one" side) and the part number field in the "add"
table (the "many" side). I set the description field in
the "part numbers" table to "Indexed (No Duplicates)" and
made sure the description field in the add table is not
indexed. I created a query with both tables and drew a
relationship in the query between the two part number
fields again (I left the Join Properties to whatever the
default is). I placed the Part Number field from the Add
table and the description field from the Part Numbers
table in the query design grid. I checked the box
indicating that both should appear, and saved the query.
When I type a part number in the add form, nothing
happens. So I either missed a step above, or a I did
something wrong. I've tried to put everything and the
kitchen sink in this post so hopefully someone will be
able to identify the issue right away.
Thanks for the help!