How to add fields to a single table?

  • Resolved kenneth0426

    (@kenneth0426)


    1 year, 4 months ago

    Hi,

    I have Table A and Table B.
    Table A has 2 columns, i.e. invoice_number, and company_name.

    Table B has 3 columns, i.e. company_name, contact_person, and email_address.

    I hope to combine these 2 Tables via “company_name”. As a result, I can view the Table with 4 columns, i.e. invoice_number, company_name, contact_person, and email_address.

    I tried to use the lookup function. However, it only can replace company_name with other fields, but not append to the original table.

    Can you give me some advices? Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How to add fields to a single table?’ is closed to new replies.