By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,291 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,291 IT Pros & Developers. It's quick & easy.

Lookup Fields

P: 69
Using Access '97

Hi there am wondering if someone can help me with the followng >>>

I have a table and am attempting to use the LOOK-UP feature in TABLE DESIGN view.

I would like to have it set up so when an end-user selects
A from the drop down in FIELD 1, then only A1 or A2 or A3 will appear or
B from the drop down in FIELD 1, then only B1 or B2 or B3 will appear, and so on . . . . .

Then once they make the selection, have both selections populate into another table that will contain fields for both selections they make:

FIELD 1 FIELD 2
A A2
B B1
C C3

Something like this. Have any ideas on how to accomplish this??

Thank you VERY much for your assistance.
Aug 10 '07 #1
Share this Question
Share on Google+
3 Replies


Boxcar74
P: 42
Easy to do two ways.


1. In the RowSourceType setting
Select Table/Query to reference a column in a table or query.


I recommend this one for you
2. In the RowSourceType setting

Select Value List and you can type in the names of the options you want for your list in the Row Source Field and use semicolons (;) as separators.

Like: A;B;C;D

-------------------------------------------------------------------------------------

Anyway best way to figuire all the settings options is to click in the option field and press F1 for Help.

F1 in the The RowSource property displays this:

For this RowSource Type setting
Table/Query: A table name, query name, or SQL statement.
Value List: A list of items with semicolons (;) as separators
Field List: A table name, query name, or SQL statement.


Basically what I said. Well almost exactly :)

Good Luck Out There!!

-Boxcar
Aug 10 '07 #2

P: 69
Easy to do two ways.


1. In the RowSourceType setting
Select Table/Query to reference a column in a table or query.


I recommend this one for you
2. In the RowSourceType setting

Select Value List and you can type in the names of the options you want for your list in the Row Source Field and use semicolons (;) as separators.

Like: A;B;C;D

-------------------------------------------------------------------------------------

Anyway best way to figuire all the settings options is to click in the option field and press F1 for Help.

F1 in the The RowSource property displays this:

For this RowSource Type setting
Table/Query: A table name, query name, or SQL statement.
Value List: A list of items with semicolons (;) as separators
Field List: A table name, query name, or SQL statement.


Basically what I said. Well almost exactly :)

Good Luck Out There!!

-Boxcar
That will only pull in A, B or C, but it will not pull in the secondary selection which would be A1, A2 or A3 accordingly.

Have any other suggestion? Maybe I should do this using a form? Not sure if this will work either. What do you think??
Aug 10 '07 #3

Boxcar74
P: 42
Ok, I think i miss understood.

So the second field is dependant on the first fields selection.

I belive the best way to handle this is in a form. But I'm not sure how.

I know there is a way. I'm just not sure if you need to add vb code to the form or if there is a build in function.

But I'm sure there is a way to do it.

Update me if you made any progress.

I will try to look into it.

Good Luck !!

-- Boxcar
Aug 14 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.