Not sure if I have set this up right:
I have a form fed by a table that is linked to a spreadsheet. I enter jobs as and when they come in. If a job comes in for the same location, the form cannot recognise it is a separate job, and when reopened, all the details are from the first job entered with that store title. How can I enter duplicate records for the same location (all other details differ) ?
Thanks in advcance for any help.
I have a form fed by a table that is linked to a spreadsheet. I enter jobs as and when they come in. If a job comes in for the same location, the form cannot recognise it is a separate job, and when reopened, all the details are from the first job entered with that store title. How can I enter duplicate records for the same location (all other details differ) ?
Thanks in advcance for any help.
