brian.curran

Change an ID field to UUID without disconnecting relationships...

Discussion created by brian.curran on Feb 10, 2013
Latest reply on Feb 11, 2013 by brian.curran

Hi all,

Can anyone advise me on the best way to change serial numbers to UUID's without breaking any existing relationships?

 

I originally designed the database using auto-enter serial numbers but changed to text based UUID's when we implemented GoZync for syncing local copies on iPads etc. As the original ID fields were changed to text fields, 'finds' are unreliable as searching for 1 will find record ID 1 and 10 etc. etc.

 

So, I now need to change all the old ID's to UUID's and would appreciate any comments or suggestions.

 

Thanks

Brian.

 

Using:

FM Pro 12 Advanced

FM Go

Outcomes