Hi I have two tables, one called CUSTOMERS with customerID as PK and then name, address, etc. The other one called ORDERS with OrderID as PK and customerID as FK. When I enter an order from ORDERS and select the customerID from the dropdown list, is there a way to display more than the customerID or Name (for example address, location, city, etc.) Thanks Rick
