Lookup, List box problems

K

Kim Noer

Hi there..

Got three tables :

TableA :
catID, smallint, primary key
TableB
catID, smallint, primary key (together with prodID)
prodID, varchar(40) primary key (together with catID)
TableC
prodID, varchar(40), primary key

The relations are :

PK table FK table
TableA.catID TableB.catID
TableC.prodID TableB.prodID

If I create a lookup on TableB.catID -
List box, Tables/Views/Functions, SELECT catID FROM tableA, 1, 1, no
- it does what I expect, looks up current values in TableA.

However, if I replicate this procedure to TableB.prodID -
List box, Tables/Views/Functions, SELECT prodID FROM TableC, 1, 1, no
- then nothing shows up!

So, any clues on why Access won't list current values in TableC (yes there
is content in TableC :)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining existing records in two tables 8
Using a combo box to change a foreign key relationship... 4
Combo box in Detail section 0
Excel/SQL Query Quandry 3
weird lookup behavior 3
Combo Box won't let me choose the values in it 10
Access frontend with SQL Server backend: my solution for ODBC Call error 1
Table Lookup Field - options relative to record 1

Top