What does this new layout represent? In the end it appears to be a report or should it be a join table and new entity. Is this final report for a specific job. IOW (and I'm just guessing) someone calls you and says they are shooting a commercial. They need Hipsters, business men, twin girls.
You then want to produce a set of found records of Hipsters, then a found record of business men, then a found set of twin girls, all on the same report, that you can save so that you can send it, follow up, etc.
Am I on the right track?
If so then think of this new join table as LineItems for a SpecificRole (Invoice). LineItems draws from Products (RoleTypes-your hipsters, business men, etc.) via by calculation or lookup. I would think your RoleTypes Table should have attributes for each person (hipster, business man, etc.). Then you can perform finds on the RoleTypes, one by one or together, flag them and drop them into SpecificRole (LineItems).
Let me know if I'm in the ballpark or way off. Either way other can chime in.
Correct! Thanks Steve. That is what I'd ideally like to do. It'll eventually be presented in a report that I can print out.
When I have it displayed on this layout..I essentially will email all of those that I have listed in the 'found set' for each role to see if they're available on the shoot date. If they are not available, i will take them off of this report/layout.
Let's see. In the relationship table screenshot I sent above, I'm still a bit confused on that logic that you mentioned. My 'Talent' table has all the attributes that I can filter by; Hipster, Business, Age Range, Ethnicity, etc. I see that you mentioned Right now, I'd perform finds on that Table, on a separate Layout 'Role 1'. How would I 'flag them' and drop them into Specific Role? Let's say I have 45 people that qualify for this role, and I want to move them all over to the report, and then i'll go to next role 'business' and I do my find with 30 business people, I want to drop them in that same layout. I guess I'm just not sure how to 'drop them' there. The fields I'd like to keep on that report are just First Name, Last Name, Phone, and Email.
I appreciate your response Steve!
There's two ways that come to mind.
Try this manually. Easiest would be to perform a find for the first group of people. Then enter find mode, check the attributes or enter into fields for the second group of people. Instead of hitting 'Perform Find', go into the top dropdown menu under 'Requests' and select 'Extend Found Set'. If you go to a layout based on the same Table Occurance, and make that a report layout, the sub-summary report can be sorted by Role. When you sort by the sub-summary field you will get something that looks like:
Businessman (this is the sorted by sub-summary part)
Dennis Williams (the names are in the body part)
Cool Hand Luke
And this could be scripted
A harder method would be to use the Virtual List Technique and compile the list the same way. If you want to check out this method, just google Virtual List Filemaker. There are plenty of examples and sample files.
Here's a few: