troubleshooting Question

Record straight and reverse assignments

Avatar of Cruizectrl
Cruizectrl asked on
FileMaker Pro
16 Comments1 Solution232 ViewsLast Modified:
I have a table with records for documents and checkboxes at the bottom that list all active employees.  for each record I can assign certain employees to each record.

I would like to somehow reverse this now to be able to do the same but flip flop the assignment to show each employee and a list of documents that can be assigned.  This would need to be dynamic in a way so when I have for example

I check employee one for document 2 4 6

when I look into the employee record I see

Employee one
doc1
doc2 x
doc3
doc4 x
doc5
doc6 x

Of course this would need to reflect in the other side.

Would this need to be done with scripting?
ASKER CERTIFIED SOLUTION
lesouef
lesouef

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros