VB6 & Access Database Issue

[phly9]

i have an access database set up with one table, the table has 3 fields (example: 1, 2, 3.)

in my vb project, i need a dblist to return all the data in field 1.
i also need another dblist to show only the records from field 2 that corespond with field 1 when a certain item is selected.

and then finaly i need a text boxt that will give the data that is represented in field 3, which coresponds to both fields 1 & 2.

anyone have any ideas? am i being clear enough?

any help would be great.
just not really sure how to set up the database and/or the project correctly.

 

[Spellman]

What way are the tables linked. Is there an ID in table one which is linked to table two's foreign key Id ? If you can give me the table setup I may be able to write a snippet of code for you.

 

[phly9]

i have set up relationships in my access database, and basically i have the 2nd table linked to the first, and the 3rd linked to the 2nd.

if i am doing it wrong, could you tell me how to set up access and/or vb so i can get it correct.

i think i might need to use a data-bound list.
i tried to set up a database with 3 tables and link them all with relationships, but after i set the primary key and set autonumbers, it won't allow me to add any info.

thanks
phly9