unrelated relationships
In our app we have the primary set of tables and then some that I would call "supporting" tables. The issue is at the lowest level, I may have all the necessary data to build a relationship but it do...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOne site has many Site Authorizations. Therefore there are many Authorization dates. How will we know which of those dates to use. Oldest or Newest or a particular one?
If we know that then we can just do a summary field where one site has many site authorizations and summarize either the minimum or maximum authorization date up to sites and then it's a simple look up back down to events, right?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If we know that then we can just do a summary field where one site has many site authorizations and summarize either the minimum or maximum authorization date up to sites and then it's a simple look up back down to events, right?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
It is a particular one. As the site authorization is also tied to the provider, each provider would only only have 1 authorization per study training/site combination and only one provider is associated with a particular event.
------------------------------
David Berndt
------------------------------
------------------------------
David Berndt
------------------------------
- MarkShnier__YouI am not sure if there's a more elegant way but you could make a text field on the site authorization record which combined the provider name with the authorization date. Then float up that combine text field up to the Sites table, then look it up back down to events. The event knows the provider and then you would have a formula that would purse out the possible authorization date provider combinations to find the one that had the right provider and turn that text format a date back into a real date field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- I played with that but when I bring it back down it is a textlist instead of text and I couldn't seem to parse it. Is there a way to convert it/parse it when it is that type?
------------------------------
David Berndt
------------------------------- I've done things similar to this and while not elegant, it works. The parsing I've done using the Part function. This means I have to break my textlist into many parts and check each part. The upside, it worked. The downside - you have to repeat the part function to be at least as many as the max number of parts possible in your string. This is practical up to a certain number, but if you will have over say 50 parts, starts to become impractical. I'm curious to know if you come up with a sleeker solution.
------------------------------
Mike Tamoush
------------------------------
