Jump to content

Multiple results from single input value


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

Recommended Posts

  • Newbies

This is eluding me. I'm hoping there's a simple answer. I have a layout showing two fields; "postal codes" and "locality", both in a single record. ie Postal code "0810" and locality "Alawa" appear in a record. I want to enter that postal code into a field in a related file and have FMP7 automatically lookup the locality corresponding to that postal code. Problem is... there can be different localities each with the same postal code appearing over multiple records. So, creating a lookup will only give me the first corresponding match (I think). I want to have FMP7 show a list of localities (records) which correspond to the postal code I have entered and then be able to select from that list. I'd be grateful for assistance.

Link to comment
Share on other sites

You could create a portal showing the matches between your entered zip code and the postal_code-locality file. Then write a script to select the portal row and put the locality from that selection into your current table.

Link to comment
Share on other sites

Likewise, you can use a Value List which displays a popup to select from. No need for script. Join postal code to postal code. Create a Value List called Locality. Select 'Use Values from Field' and select 'only related values' and specify this new relationship. Then select your Locality field.

When Users select the postal code, the popup will filter to only display corresponding Localities.

Link to comment
Share on other sites

  • Newbies

Errr...you're reading it wrong. It's an Australian phrase thanking someone who provides an answer or a gift. It's actually a term expressing a great deal of gratitude. I have implemented the solution and whilst there are a couple of issues I need to sort out, I am very grateful. Fair enough?

Link to comment
Share on other sites

I see. I've read and heard it is a reference to Thomas Austin bringing the plague of rabbits into Oz, which was not a good thing. So it's thought of as a sarcastic remark that 'reflects the attitude of a lot of Australians about the early English basically stuffing up the country.'

Link to comment
Share on other sites

  • Newbies

I have better things to do with my time than get into an argument about one persons interpretation of a colloquial phrase. Where I come from, if someone says they read it a particular way i.e. "they are grateful", no matter what the historical minutae may or may not be, that's generally respected for what it is and the matter is left to be. A lecture from you on the "attitude" of Australians based on a somewhat contentious thread in another forum is not only insulting, but also demonstrative of a shoulder laden with a large chip. Please be advised that I ain't playing that game and would be grateful if you let the matter rest. To the other gentlemen who replied to my original post, I sincerely thank you and am indeed grateful for your assistance. Your suggestions have worked and have made a somewhat onerous task a heck of a lot easier. Cheers.

Link to comment
Share on other sites

This topic is 7093 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
×
×
  • Create New...

Important Information

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