I have external data coming into QuickBase directly from sql tables (via Qunect).
There is a companies table and 2 additional tables which hold Region, Territory and Buyers data.
eg. companies, , spaccanl, spanlidn
In the companies table there is a ref for each company.
In the spaccanl table the ref exists agains each type of entity... Region, Territory, Buyers etc.
In the spanlidn table there are fields Region, 01, SouthWest
I can’t figure out how to link it?
REF: XC001, ANLTYPE: REGION, ANLID: 01
REF: XC001, ANLTYPE: TERRITORY, ANLID: 22
REF: XC001, ANLTYPE: BUYER, ANLID: JB
ANLTYPE: REGION, ANLID: 01, DSP: SouthWest
ANLTYPE: TERRITORY, ANLID: 22, DSP: Essex
ANLTYPE: BUYER, ANLID: JB, DSP: Julie Brown
How can I show on the Companies form or reports that:
The region for XC001 is SouthWest
The territory for XC001 is Essex
The buyer for XC001 is Julie Brown
Bearing in mind that the tables are synced in directly.
Any help appreciated.