Creating new entries based on a portal
I think I might be FM'd out for today. But here's my current stumper.
I have a portal pointing to a table called Job List, which is a list of all the employees and their associated job sites. I have another portal on a different layout that filters this list based on the user that is logged into the database. This portal only shows the relevant job sites.
Each row of the portal has a create new record button that goes to a inspection layout. This layout is suppose to have job sites copied over from the portal but this only works for the first record in the portal. Creating records in the subsequent portal rows results in the same job site as the first row.
Part of me thinks I need another table but I cannot think of what this table would do or look like.