How do I make a combo box that performs a lookup based on earlier choices?

[Vulfson]

Hello everyone.

I am trying to create a drop-down box that displays the values of another field. The problem is that the combo box is both related to the other table, and is part of a composite key.

Table1
ID -Pkey
ContractNo -Fkey
ContractID -Fkey


Table2
ContractNo -Pkey
ContractID -Pkey



What I am trying to do is make a set of two combo boxes. The user would select ContractNo, then be able to select ContractID from a set of second fields based on the first choice. Do I need a special SQL statement to get this to work? I am still quite poor at writing my own statements, so any help here would be greatly appreciated.

 

[neileg]

This is known as a cascading combo. Do a search here to get lots of help.

 

[ColinEssex]

and there's a sample Db in the samples forum

Col