Question about ref fields.
I’m building an app for shift reports. Say i have 3 tables:
Operators Shifts Reports
I create a report first then from within that form i create or choose an existing Shift. All good so far. Each shift will have its details and the operator as well created or chosen from within that form.
i’d like to be able to link the report to the operators as well so i can see what reports each operator has written. Shouldn’t i be able to do this with a ref from reports to Shifts and then shifts to operators?
i can’t seem to figure out how this is done. Any help would be great.