Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Possibly a join table? I'm not sure

  •
emjay
in Finding & Searching

Featured Replies

Greetings,

I have a flat file mailing list with about 2000 names and 400 unique zip codes. I created a separate table for the zip codes (thanks fmforum). Now what I want to do is select a subset from the zip code table and print out all the addresses for that subset.

What I can do is create a find for the zip codes in my zip code table and then do multiple finds in the mail address table. I'm doing this using the loop and next record script steps. But it seems there should be a better way.

It seems like it should be a join table but there is only the 1 key, that is, zip code.

Any recommendations will be much appreciated.

Cheers,

MJ

From ZipCodes to Names, Go To Related Record [ zip code relationship, Names layout; Show only related, Match found set ]

  • Author

Thanks for your reply but if you have a moment could you please be a bit more detailed. You're dealing with a dunce.

Cheers

MJ

  • Author

Actually, thanks again. I worked it out.

Cheers,

MJ

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.