0

Convert table to subtable

I would like to turn a table (B) into a subtable of Table A. Table B provides reference to A already. 

Many thanks in advance.

3 replies

null
    • Alain_Fontaine
    • 2 yrs ago
    • Reported - view

    If table "B" already has a N:1 reference field to table "A", just edit this field and set "Composition" to "Yes" to make table "B" a subtable of table "A".

    • John_Halls
    • 2 yrs ago
    • Reported - view

    Hi GB

    This is called Normalisation where A is a flat file that has repeating fields that you would like taken out of A and put into B. It reduces redundancy, and makes for a more manageable system.

    Can you confirm that this is what you mean.

    Thanks John 

    • Compleasy
    • silver_bee
    • 1 yr ago
    • Reported - view

    Thanks both. Composition did the trick!

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 196Views
  • 3 Following