combobox

[Andy]

Hello friends,

I have 3-Tables.
Table1has some fields: Item#
Table2 has fields like this: Item#,Loc#,Station
Table3 has fields: Item#,Loc#
Table2: Item# has combo box which look into Table1. Now Table 3's
Item# and Loc#has combo box each looks into table 2.

Table2, for each Item# has 50 to 60 Loc#. How would I ristrict LOC# combo
box of table3 So It shows only locations that belongs to Item# selected in
table3

Andy

 

[Jeff Boyce]

Andy

From your description, your "tables" have "combo boxes".

If so, this is the dreaded "lookup field". Well, some folks dread it,
mainly because it stores one value but displays something else, causing
consideration confusion. If you want to use a "lookup", use a combo box in
a form. Access tables store data, Access forms display it.

JOPO (Just One Person's Opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Andy]

Jeff,

Thanks for replying me.

I am not a Access guru !!!! I read ppl's Questions and answers & I am
developing my Tables and reports. As u said, Yes I have combo box in Table 3
which shows whole long list of Items and Locs which i have to scroll to
selecy the required record. I have no idea how to use form to solve this?

Andy

 

[Jeff Boyce]

Andy

Store the related table's rowID in your field, rather than having it appear
to be the "looked up" value.

Create a query that joins your Table3 with the table that holds the lookup
value.

Create a form, based on that query. For the control on the form that holds
the ID of the looked up value, use a combobox (or listbox if the list is
short) and base the combobox itself on another query that "looks up" the
values from your lookup table.

That's a rough outline. Post back with specific questions for specific
suggestions.

Good Luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP