Forum Discussion

DougHines's avatar
DougHines
Qrew Trainee
4 years ago

Filtering Related Parent based on values in Child table fields

The subject may sound similar, but I've not come across something like this in the forums yet.  Maybe it's not possible and I just haven't joined the bandwagon yet. Imagine, if you will, a table of...
Relationships
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
Is there a common Parent table to both Orders and Contacts by chance? Like maybe a Clients table or something?

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
DougHines's avatar
DougHines
Qrew Trainee
4 years ago
There is not. They are directly related to each other.

------------------------------
Douglas | dhines@tritonnet.com
|
Service Delivery Coordinator | Tier II Support | Systems
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    Ok, so you mention that you're trying to connect them via the Main POC. How is this person associated with each Contact? And how - in actual practice, not necessarily in Quick Base - would someone identify the Main POC and then identify the viable Contacts from the larger list?

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------