I am in need of some help please.
I have an app to create jobs. When the job is created the job has a record id [jobrecordid].
I select or create a client. If creating a client I’m taken to a new page to complete the details then it is given a record id [clientrecordid]
I select or create a site. If creating a new one i am taken to another form and the row is given a record id [siterecordid]
I have another column in the site worksheet for client ref. I want this to capture the [clientrecordid]
Please please can someone tell me how to do this, it would be greatly appreciated.
I capture the client ref against a site so that I can filter the options available elsewhere in the app