OWMAX

Thank you again for everything. I will try and figure that out. M

Thank you! I'm now having a horrible time adding this relationship. Here is the file. I'm failing. Help! I have added the portal in the Data Entry Layout and the Notable layout but I can't get them to populate from my related Invitations_MediaLists join table. Help! ack.

Sorry bout that. We use our DB to send invitations to notables to events. I have a value list made of events to invite to. That being said, there are three of us here that reach out to contacts, and we set who is in charge of each notable each time we do an event (so they are not the same). I'm trying to figure out if there is a way to have this info (which person on my side is point) on a value list without creating another join table with the "Invitations". If I do create a join table, it will be pulling information from the reps, celebs, and our media db and I will put portals on each of the screens I need to. I hope this helps?

Amazing! It seems to work! The join table did what it needed to! I have one other question for you....in the same file and the same set of tables, there is a value list for invitations that we send to these notables. I have set that up as a check set value list which is fine, but one of our three principals leads the relationship, but changes between invites. Is there a way to note that without creating another join table with our invites or should I just do it that way? Thank you for all of your amazing advice!!!!

Thanks for your advice. I'm going to try a join table with the multiple in the am when I have my notes from home. I guess my only question is that the Rep names are two fields - first & last. With that in mind, to select by name, then have the RepID autofill on the join table, is there a way to look at both fields as one to select?

the matching fields would be Agent (in Notable) to Representative Name (in Rep). Should I try and add a serial field?

I am an intermediate user of FM8.5 and am in the process of updating my company's DB. We are tracking Notables in one table and Representatives in another. In each Notable, there is an agent, manager and publicist selectable by field. The relationship back to Representative is a "x" connection. I would like to add a portal to the representative's layout which shows all notables they represent but can't make it work. Either shows all Notables in list or nothing. Any advice would be much appreciated.