Jump to content

  •  

Photo

Problem with relationship


  • Please log in to reply
2 replies to this topic

#1 JTSmith  apprentice

JTSmith
  • Members
  • 145 posts
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 3d 2h 33m 30s

Posted 17 February 2012 - 12:26 PM

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!
  • 0

#2 efen  master

efen
  • Members
  • 539 posts
  • FM Application:8.5 Advance
  • Time Online: 2h 33m 28s

Posted 17 February 2012 - 03:08 PM

Attached is one way

Attached Files


  • 0

#3 JTSmith  apprentice

JTSmith
  • Members
  • 145 posts
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 3d 2h 33m 30s

Posted 08 March 2012 - 01:35 PM

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!
  • 0




FMForum Advertisers