Primary Key change

Firstly, you can always copy your app and do the change there, just to practice and see in advance what it will do.

You will set the Key field and it will give you two scary warnings and then in a blink it will change the Key field and update all the child records so they stay connected to their original parents.

Then you will go to each affected relationship to identify a Proxy field for the [Record ID#] field.  For example if the Customer name was the Key field of the Customers table and now you want to go to [Record ID#],  then you go to the Related Customer field, remove the (ref) suffix which QuickBase added, and set the Proxy for [Related Customer] to be Customer name.

Then go to the form on the child record and make sure that Customer Name is on the form and Related Customer is not.

Then test the drop down for choosing the customer. (Parent) 

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Edit: I wrote everything below before read Mark's reply. Mark, I seem to remember it did not re-associate the children when I went from text to numeric (only if I went from numeric to numeric). Perhaps I am misremembering? Mark has way more experience, so you may be able to ignore everything I wrote below!

----------------------------------------------

[Deleted Response]

------------------------------