1 Reply Latest reply on Oct 7, 2014 7:55 PM by philmodjunk

    Bringing up the appropriate address coordinating to the city

    FeldyNYC

      Title

      Bringing up the appropriate address coordinating to the city

      Post

      I have Gallery with several Addresses - one in NYC and one in London for example.  

      Gallery Table and Address Table

      I tried to bing up only Galleries that have an address in London, but if there is a NYC address it comes up instead.  How can I can I just do a find for london addresses and only have London come up?

      Thanks

        • 1. Re: Bringing up the appropriate address coordinating to the city
          philmodjunk

          What is the relationship linking Gallery to Address?

          Sounds like you are performing a find on a layout based on Gallery, when you should actually perform the find on a layout based on Address.

          When you do a search on the Gallery layout by specifying a City from the related address table, you find all Gallery records that have at least one related address record located in that city. Once the find is performed and you return to Browse mode, the Gallery records thus found will link to all related address records, not just those located in the specified city.