Connecting Tables

[Guest]

I have a database with several tables. Customer, Contract, Purchase Order
ID#, Purchase order Details, Sales Rep., Sales Commission ID#, & Sales
Commission Details Table.

The Sales Commission ID Table looks for the Sales Rep. The Sales Commission
Details Table looks up information on the customer ID, the Sales Commission
ID, & the Contract ID Number.

I need to pull information from the Contract Table such as contract date,
commission, etc. Is there a way I can do this to that the information is
automatically pulled from the proper table. The way I've been doing this (as
a look-up) I'm getting a drop down box with a list of all contract dates on
all contracts ever entered.

 

[Guest]

I got it figured out. Needed even more tables to be looked up from the
contract table.