Forum Discussion

Stephony_DBH_'s avatar
Stephony_DBH_
Qrew Cadet
9 years ago

Is there a way to copy fields from one table into another

I have two separate tables that will have around 100 of the same fields. The tables are separate and the information can not be put into one table due to process and policies. Is there an easy way to ...
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
9 years ago
1) Will your second table essentially "duplicate" the first table; but only have certain fields in it?
2) Will your two tables have the same Key Field if they are not duplicates?
3) How will you update your second table?  Record by record or in bulk?
  • Laura_Thacker's avatar
    Laura_Thacker
    Qrew Commander
    9 years ago
    Another option is to create a relationship between tables A and B and push all the fields down as Lookup fields - you haven't really commented on why you would duplicate data instead of control access permissions etc; or whether the data is supposed to be "aligned" or could potentially change in either table....