Problem with relationship

[JTSmith]

Ok, here is what I need to do, and I can't seem to figure it out...

I have a table of Properties. Each property record has about a hundred fields (Size, Address, etc)

I have a table of Quotes. Each quote record I put the person's name, email, etc and I want to be able to provide them with a quote on the property they choose, and say "A 1 bedroom will be $1,000 per month, etc. etc" and when I select which property it is, I want it to pull some of the data over like size, address, amenities, etc and some photos in container fields, and then I can print it as a PDF and send it to them.

Any thoughts on how to structure it?

Thanks guys!

[efen]

Attached is one way

property.zip

[JTSmith]

Hey, sorry for the delay, I wanted to say thank you. I had a few minor issues with mine, but I followed how you did it and it solved my problem!