Discussions

 View Only
  • 1.  Relationship question

    Posted 05-23-2019 23:12
    I have 2 tables, Companies (Clients) and Vendors (both contain data but no relationships setup between them).  On the Companies table I have several fields I want to pull a Vendor name into...

    Archive Vendor
    Software Vendor
    Portfolio Vendor
    Etc.

    On the Vendor Table I want it to have a field with all the names of the Companies...

    In other words if I enter Vendor X into the Archive Vendor fields for each of the three separate Companies and then go into the Vendor Table under Vendor X I should see all 3 Companies Names there as well.

    Of course it would be even better if it worked both directions...

    If entered into Companies fields automatically stored in Vendors
    If entered into Vendors fields automatically stored in Companies