Skip to main content
Question

Relationship Issue

  • February 5, 2020
  • 0 replies
  • 26 views

Forum|alt.badge.img+8

I have a heck of a time getting my mind around this relationship, fumbling around every time with it.

In the Parent Table – Resets, I use a text-formula field in the Resets Table to create the ResetID#, this ResetID# is then passed to the Child Table – Travel, when a new travel record is created for a given reset. A reset can have one travel record or innumerable travels.

Now what I want to do is reverse the order, where the Travel becomes the Parent Table and Resets becomes the Child Table. What I need is to pull back to the Reset Table the associate that is the assigned Lead for a Reset (Reset Lead). Of course, the common denominator is the ResetID# in both tables. The ResetID# is not the key field in either table. So, how can I make this field a relate-able field in both tables?

​

------------------------------
Hans Hamm
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • Quickbase Alumni
  • February 6, 2020
Hans,

It is hard to follow your description.  Is this what you are talking about?



------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------