Filter subform lookup

[saultpastor]

I have a browse/edit form for employees(PK employee_id). Once I select an employee, I have 4 tabs, the first is the edit form for contact info of the employee, the second is the equipment assigned (PPE) to the employee and the browse/edit form (PK ppe_id FK ppe_assign) is a run object on the PPE tab in an iFrame and it is filtered by #RECORD_ID# (Screenshot-1) This works properly

screenshot-1.png

The Third tab (Inspection) has an edit subform (PK inspection_id FK insp_ppe) with a lookup object that uses the same ppe form from the PPE tab. I have also made an object for employee_id for development purposes circled in red on screenshot-2

screenshot-2.png

screenshot-3.png

screenshot-4.png

Screenshot 3 shows the form listing the assigned equipment to select which piece of gear has been inspected. the first 6 pieces of gear are correct and correspond to the employee whose record is being edited, the seventh is another employee.

I've tried WHERE statements and changing the SELECT and JOIN tables with no success, I cant seem to get the employee_id from the original browse/edit form to the subform lookup object. Is this possible? Also, I have an arrow on screenshot-2 showing the header for the form stopping at the last object in the iframe. Is there some reason for this? If I make the iframe fit the edit form then the lookup doesn't fit. Also, I think the solution might be with hash cookies but I have looked for a clear tutorial on how they work and I haven't found anything I understand in the documentation or the forums. I have seen the video, slowed it down watched it multiple times and I just can't get it to work. Sorry if this is really simple.

Thanks, Craig

[kev1n]

Hi Craig,

I saw that you have joined Discord. Please check the messages that we posted.