3 Replies Latest reply on Oct 14, 2013 11:28 AM by davidanders

    Some help please.

    KevanGordon

      Title

      Some help please.

      Post

           Hello all,

           I have been asked to put together a database to collect info on Clients, Staff and Jobs. I am stuck on getting one aspect to work.

           The database has 3 tables (Client,Staff,Job). From the Client layout, clicking on the 'Create New Job' button works fine and, once the Job has been created, it shows up in a Portal on that Client's page. Clicking on a line in this portal takes you to the relevant Job record. This all works fine and I understand how it all works.

           On each Job record, I have a repeating field (40) that is a pop-up and is populated from the records in the Staff Table (a combined FirstName/LastName field). This allows Staff to be 'assigned' to each Job.

           What I cannot figure out is how to have a Portal on each Staff Member's page that lists all of the Jobs they have been assigned to.

           Happy to provide further info, as requested. Not sure if I can upload my database to here.

            

           Thank You!