Simple Newbie Question

[INFRA]

I am very new to FM, so please be patient with my ignorance.

I'm trying to make improvements to a database that I did not build myself. So I am still struggling to understand some of the ways this database works

I have records for "members" and each member has multiple location addresses associated with it. The multiple locations are entered into a portal linked to the members by a member ID number.

I need to build a script that returns members locations based on an option selected in a drop down menu field that is part of the portal. So for example, a location could be a Store Front, and Office, or a Warehouse. These are the three options in the drop down menu. What sort of function do I use to return all Store Fronts?

[bcooney]

Welcome to the forum, AAshindelar.

You are describing a "filtered portal". Do your addresses have a field that contains their type; "Store Front, Office or Warehouse?" You would create a global field in the Member table, put it on the layout, above the portal and set it to a value list of address types. Then add to the portal relationship a second criteria in addition to the existing Member::MemberID=Address::MemberID. The second criteria for the relationship is Member::gFilterAddrType=Address::AddressType.

You do not need a script.

[INFRA]

Great! Thanks. I'll give that a try.