Lookup Fields

[KMEscherich]

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.

[Boxcar74]

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

[KMEscherich]

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??

[Boxcar74]

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