I cannot seem to figure out the relationship I need to make this work. I have a portal "vessel assignments" and I have a field on the portal (or I want to put a field on the portal called"job number".
I made a table for jobs because I want to capture more info about jobs and I of course have a vessel assignments table. I have tried ever variation I can think of but I cannot get the job number field in the portal to show up, cannot even click in it. Any help is appreciated, I am uploading a couple of screen shots.