Assign additional value to single ID

[mdriden]

I am wondering is there a way to create a macro that will add an additional value to an existing value without overwriting the previous value.

For Example:
I have a form that contains customer information. One of the things this form holds is a job number for the customer. I am looking for a way to have the same customer information available but to add an additional job number at a later date if they come back wanting to add to a previous job. I would like to open the form and hit new job for the customer and have it open a field where I can assign a new number without overwriting the previous number.

I am working on Windows 10
LibreOffice 7.2.5.2 (x86)
Java 8 (x86)

Any advice on how to accomplish this would be greatly appreciated.

[Wanderer]

@mdriden

… macro that will add an additional value to an existing value without overwriting the previous value.
…
Any advice on how to accomplish this would be greatly appreciated

Just do it. The problem is not creating this second number in a macro, but “where shall we store the new number”.
.
Usually this is a big change in your database structure, because you change from 1-1 relation customer-job to another type 1-n, where a customer can have multiple jobs. So you need a table with all jobs and to wich customer they belong.
Then all your macro needs to do, is adding a new row/record to this table. The job-number may even auto-generated as unique id. Then you store also the id of the customer in this row.

[Ratslinger]

Hello,

Do not see the need for any macro or adding job numbers onto other numbers - all seems messy. Just create a third table of RelatdJobs. Basically the same information as Jobs table and links back to it. On form you would have Customer->Jobs->RelatedJobs:

[mdriden]

Going off of Ratslingers suggestions I was able to accomplish what I needed.
No macro’s needed which is always better.
Thank you very much for your guidance.