AnsweredAssumed Answered

lookup from multiple sources(tables)

Question asked by WilliamChang on Aug 4, 2011
Latest reply on Aug 5, 2011 by philmodjunk

Title

lookup from multiple sources(tables)

Post

hi,

I'm working on a donor/donations tracking application for my son's K-5 school and could use some advice.

I have a Donors table that holds donor records including address information (address, city/state/zip).

There are also a Parents table that holds records of parents of students at the school including address information and a Families table that holds records of families including address info.

The Donors table has foreign keys ParentID, and FamilyID pointing to the Parents and Families table respectively.

In the Donors layout, there are the fields FamilyID and ParentID; and either or both can be populated.

The behavior that I want is,

- if the user populates the FamilyID from a drop-down menu list, the address data from the Family record will be copied over to the address fields on the Donor layout that are associated to the Donor table.

- if the user populates the ParentID from a drop-down menu list, the address data from the Parent record will be copied over to the address fields on the Donor layout that are associated to the Donor table.

- if the user populates the FamilyID field first, then populates the ParentID field, the address data from the Parent record will be overwrite the address fields on the Donor layout that are associated to the Donor table.

Is this behavior possible to code? I can't use a Lookup as my understanding is that you can only associate fields/columns on a given table to corresponding fields/columns on one other table.

I'm open to putting buttons on the layout that would effectively be "copy family address" and "copy parent address" using the FK in the FamilyID/ParentID fields but I'm not sure how to write that scripts.

I'm new to filemaker pro, but I'm quite familiar with database applications (specifically Oracle). I would greatly appreciate any advice anyone can offer me.

Sincerely, William

donorapp.jpg

Outcomes