Host: FMS 16.x
Clients: FMP 15
Data input layout allows a person to "sign-off" on an analysis (two persons required). Signatory 1, and Signatory 2, confirm data within the record.
Once each confirms the data, a field is to be populated with their formal signatory title (based on user account record in a user table).
A report is generated and their titles/qualifications are presented in the appropriate place below where they will sign.
This works great locally, but on the server it does not. The Report_details field is not updated with the technician on the server, but it is on a local file. I'm not married to SQL, so happy to do anything that will insert the formal title when a tech signs-off (a check box).
Here's the query that works locally, but not hosted:
SELECT UserList.gemlgstReportName FROM UserList WHERE UserList.FMPacctName = ?";"";""; Report_Details::gemmologist_1
Thank you for putting your eyes on this.