Lookup??

[TimjHebert]

Hi Everyone!
I have a database with 2 tables. One table is Contacts and the other is rent. I would like to build a form and have a Combo box to select the Customers and auto fill their information. On that same form I would like to also have the fields to be manually filled for the rental information. What would be the best way to accomplish this.

Thanks,
Tim

 

[Fizzio]

Think carefully if you need to actually store the information in a different place or just need to display it. There is no reason for storing the same information twice in a Db (violates 1NF) except if you are stipulating a delivery address (for example) that may or may not be different from the customer address.