Jump to content

showing one (single) address under contacts


achtung515
 Share

This topic is 2608 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello - First thanks for taking the time to offer your input.  I appreciate it.

I am a novice to filmmaker but have spent a great deal of time researching it and studying it.  I have built a couple "trial" databases.
 

I am now working on a database to hold all of my real estate business information.  For the problem situation at hand I have three tables I am looking at: Contacts, property Address, and a jointable for them.  

I would like the home address or mailing address to be supplied on my contact cards.  But many contacts will be linked to many different properties.  So I am assuming I will want a field dictating which property is a "home address" in the property address table.  Then I am sure I can dictate to only show the address on the contact card that has that field populated with that value (dictating home address).  

I think i am on the right path there.  My question really lies within the reverse.  If I am on a contact card and I want to populate a home address and have it populate in the address table and be marked with home address in that field, will file maker do this on its own, when i populate the field on contact card?  

Link to comment
Share on other sites

I am not sure I understand your question that well, but I do understand this:

 

So I am assuming I will want a field dictating which property is a "home address" in the property address table.

 

No, that is not the correct approach. If a contact can have only one property selected as the "home address" property, then this selection is an attribute of a contact and should be recorded in a field of the Contacts table, say Contacts::HomePropertyID.

 

Once you have that, you can show the selected property's address on the contact's layout either by defining an auxiliary relationship :

 

Contacts::HomePropertyID = Properties 2::PropertyID

 

and getting the address from there, or by filtering a portal based on the existing relationships.

Link to comment
Share on other sites

  • Newbies

Makes sense.   Thank you - much easier.

 

One thing i have learned thus far, is it is very easy to completely over think it.   :)

 

I don't fully understand what the purpose of the auxiliary relationships are?  Why wouldn't I just pull that info from the primary property table?  I can even do that without a portal, right?

Link to comment
Share on other sites

I don't fully understand what the purpose of the auxiliary relationships are?  Why wouldn't I just pull that info from the primary property table?  I can even do that without a portal, right?

 

The best way to understand why this won't work would be to try it, I think. Then you would see that, without a portal, any field from Properties placed on a layout of Contacts will show data from the first related record in Properties. This is not necessarily the record of the property selected as the "home address" property for this contact.

Link to comment
Share on other sites

  • Newbies

The best way to understand why this won't work would be to try it, I think. Then you would see that, without a portal, any field from Properties placed on a layout of Contacts will show data from the first related record in Properties. This is not necessarily the record of the property selected as the "home address" property for this contact.

 

Thank you - I know these questions must seem silly to some people... So I really appreciate you taking the time to answer them.

Link to comment
Share on other sites

Questions are not silly.  We all must go through this process of testing and questioning and studying.   Ignorance is not stupid and you are trying to understand the principles beneath.  Good on you.  

  • Like 1
Link to comment
Share on other sites

This topic is 2608 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.