Possibly a join table? I'm not sure

[emjay]

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

[Fenton]

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

[emjay]

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

[emjay]

Actually, thanks again. I worked it out.

Cheers,

MJ