Splitting one table into two
Hi I want to "create a new table" from a field in one table and want to move the address field across to the new table but it doesn't show as an additional field I can move. Currently have one table ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCharmaine
This can be done natively with a few clicks.
You can copy the table to create the new table and then hack away all the fields that you do not need. Just run a checkbox down all the fields you don't need. There will be a button to Copy Table on the Table Home page.
Just set up a saved table to table import and copy across the records into the contacts table. You will find it lets you map across the address field components. In fact, the fields will auto line up correctly as they will have the identical spelling if you create the table as a copy Be sure to map the [Record ID#] field into the field for [Related Company] in Contacts.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This can be done natively with a few clicks.
You can copy the table to create the new table and then hack away all the fields that you do not need. Just run a checkbox down all the fields you don't need. There will be a button to Copy Table on the Table Home page.
Just set up a saved table to table import and copy across the records into the contacts table. You will find it lets you map across the address field components. In fact, the fields will auto line up correctly as they will have the identical spelling if you create the table as a copy Be sure to map the [Record ID#] field into the field for [Related Company] in Contacts.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you - please can you confirm which records I should delete from the copied table - the contact details or the company details?
And then copy the contacts details from the original table ? or copied table to a new table? Sorry I am getting myself confused. Can you just add which tables I am using in your above answer and I should then be able to do it.
------------------------------
Charmaine Silverman
------------------------------
And then copy the contacts details from the original table ? or copied table to a new table? Sorry I am getting myself confused. Can you just add which tables I am using in your above answer and I should then be able to do it.
------------------------------
Charmaine Silverman
------------------------------