Forum Discussion

BradElmore's avatar
Qrew Assistant Captain
2 years ago

Help with creating a Relationship using a Report Link Field.

I have three tables across 2 Apps:

App 1 - Table A (Customers) - Parent to Table B (App 1)

App 1 - Table B (RelatedGroups) - Union Table - (between A & C)

App 2 - Table C (Groups) - Parent to Table B (App 1)

App 1

-Table A (Customers) is the Parent Table to Table B (RelatedGroups) – 

-Table B (RelatedGroups) are Groups that have been confirmed/validated (Related Groups) to have a relationship with Table A (customer).

App 2 - Table C (Groups) – this table holds a list of Group records – 

*A Customer record may be related to multiple Groups AND a Group record may belong to multiple Customers (thus union table B).

On a Customer record form, I have 2 views that display Groups.

1st View) Relationships (confirmed/validated) -between Table A (Customers) and Table B (RelatedGroups) - I considered the relationships in this view as "confirmed/validated".

2nd View) This view is based on a [Report Link Field] - displaying possible relationships - between Table A (App 1) and Table C (App 2) -- Report Link field -- based on  Customer Table A [City] and Group Table C [City].

The 2nd view is used to help identify possible related Groups -- that should be in the 1st View (confirmed/validated related groups).

Is it possible to have a "button" field that appears within the 2nd View....So that when an app user identifies --- a "confirmed/validated" related Group -- ---- can click this "button" -- within the 2nd View (which is a report Link/View) – that creates a record within Table B (RelatedGroups) – as well as establishes child relationships between Table A (App 1) and Table C (App 2).

Any advice is greatly appreciated. Thank you

Brad Elmore
No RepliesBe the first to reply