I have master blocks of code in my code table.
in another table - main table -I wish to get data from a field in the code table by specifying it’s rec ID. I will then combine this code with other data from the main table.
I can do this with a linked table but it requires that the user must remember to select a record every time a new record is added in the main table and since there is no default for linked record, I cannot find a way of using linked records.
i was hoping to create a formula that did this get(field.codeTable(recID))
I could put the actual field data from the record in code table directly into a formula but then every time my code is updated rather than update the code table code I have to remember to do this elsewhere.
any help much appreciated, perhaps a script?