Forum Discussion

JUANRUAI's avatar
JUANRUAI
Qrew Member
6 years ago

Table-to-Table Relationship

Hi, I want to create a new relationship between two tabs to look up two fields. The relationship setting is done, but the value didn't pick up from the other tab. I don't know how to fix it. I...
Relationships
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Juanru,

To look up a field from a parent table, you have to edit the relationship.

From either the Parent or Child table, Click the settings Icon

Then click Table to Table relationships

This will show you all the relationships for the table.  Click on the on that you want to pass data from the Parent to the Child

Now click the button Add Lookup Fields

Then you select the fields from the Parent that the Child will inherit.


Now you can use that information in the forms and workflows of your Child Table.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
BruceKasen's avatar
BruceKasen
Qrew Member
6 years ago
Don, you helped me last week with a phone call.  Thank you much.app

Now, I also have a similar problem with the T-T relationship.  I followed your instructions to Juanru, but it didn't link up.  Would you have time for a short call you proxy into my app and help me?

Bruce
202-885-2881

------------------------------
Bruce Kasen
------------------------------