Yes, but why would you want to? If they are background linking tools that you are not using in real time, why does it matter if they have the prefix?
In a script:
Show all records
Set Variable [$ID ; Value: YourIDField]
SetField [ YourIDField ; "tbs-" & $ID ]
GoToRecord/Request/Page [Next ; Exit after last]
Run it once and be done with it.
You can put the "tbs-" value in a different field and use either merge text or a calculation field to disply the combined value whenever you need that on a layout.
You can also use Replace Field Contents with the calculation option instead of a looping script to update your serial number field with this text.
well this is the issue im having. I have 10 DB'S thar are 100% identical just different information in each.
everything is linked by student id.
What im trying to do is link all 10 dbs into my master db for report purposes.
1. i need a quick and easy way to import all 10 db records to the 1 db. ( everytable and every feild)
2. i need to change all linking id's in each db and set the id to a unique one to differ all dbs and ids.
i hope this makes sence.