JeffHughes
14 days agoQrew Trainee
Limit Relationship Choices based on another field..
So I have a table, Purchase Orders. That table is a one to many child of Jobs. It's also a one to many relationship of Daily Reports.
Daily Reports is also a child of Jobs.
What I want is for user A to login, and enter 5 POs, and link them to Jobs.
Then, user B logs in and clicks the "Related Daily Report" field and it's limited to ONLY the jobs selected by user A.
Is this possible?