MS-Access Referencing table data?

[DJFuji]

I'm not real experienced in MS-access and was wondering if anyone else could help. I have two tables, one more comprehensive than the other. All of the smaller table's fields are present in the larger table, though they arent linked in any way. I want a button on a form to take one record from the smaller table and place all of its data to their corresponding fields in the larger form. Basically, I'm trying to write a db program for a service industry company, and the smaller form is basic information needed for a price quote. (larger db is for current customers) I want a button on the form to say "job sold" and when you press it, it adds all the data collected into the larger table (customer table) and then you can fill in the rest of the data from there. Unfortunately, i dont think u can just reference data like in vb. It would be something like: "txtsqft.text=table1.sqft_of_house(2)" I've messed around with tabledef which sounded like it might do the trick, but i didnt really get the hang of it. Any ideas on how to accomplish this?