# Relationship w/ affiliates - advise please **URL:** \ **Category:** Ask for Help\ **Created:** [September 14, 2020, 2:53pm UTC](https://community.glideapps.com/t/relationship-w-affiliates-advise-please/15770 "2020-09-14T14:53:51Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [September 14, 2020, 2:53pm UTC](https://community.glideapps.com/t/relationship-w-affiliates-advise-please/15770/1 "2020-09-14T14:53:51Z")
Hello 🙂 - I must have been starring at Relationships for too long and as it simple as it might be, I’m hitting the wall: for reference you can view the app here: [app.lanesboro.com](http://app.lanesboro.com) In this scenario, I have a number of business members who have affiliate businesses – their primary business (parent) and additional one(s) are considered affiliates (=children) I’ve composed sheet in two variations: **Sheet Var 1:** | Parent | Affiliate (children) | | --- | --- | | Business A | Affiliate Business A1 | | Business B | Affiliate Business B1 | | Business B | Affiliate Business B2 | | Business C | Affiliate Business C1 | | Business C | Affiliate Business C2 | | etc. | | **Sheet Var 2:** | Parent | Affiliate 1 | Affiliate 2 | | --- | --- | --- | | Business A | Affiliate Business A1 | | | Business B | Affiliate Business B1 | Affiliate Business B2 | | Business C | Affiliate Business C1 | Affiliate Business C2 | | etc. | | | Then of course I have a sheet “Businesses” with all their information (address, phone, category, etc.) For some reason, I was perfectly fine when creating a categories relations (followed the instructions from docs/video – very useful as things can get muddy once you stare at it for many hours :D) But with the affiliate relations - nada… I’m hitting the wall and spinning when attempting to create relationship columns and then add the inline list so that when you view a Parent Business, you can see the affiliate businesses (and ideally, when you view the affiliate =children, you can view the associated businesses incl. the parent) Would you please help me to see the light here 🙂 – thanks so much!! ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [September 14, 2020, 3:07pm UTC](https://community.glideapps.com/t/relationship-w-affiliates-advise-please/15770/2 "2020-09-14T15:07:20Z")
On your businesses sheet: Relate to items where value in: “Business name” Matches Value in “Sheet Var 1” --\> Parent For reverse relation: Relate to items where value in “Parent” Matches Value in “Businesses” --\> Business name I think this should work, you wouldn’t need “sheet Var 2” ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [September 14, 2020, 3:51pm UTC](https://community.glideapps.com/t/relationship-w-affiliates-advise-please/15770/3 "2020-09-14T15:51:10Z")
Thank you! Perhaps my confusion has to do with still digesting the ins/outs of glideapps: lets start with what I want to accomplish: since all businesses (parents and affiliates) have record (with unique ID) in “Businesses” sheet, creating an “Affiliate” sheet (= agreeing to Var 1), in my mind, connects the values (i.e. image, business address, etc.) with the record in affiliate – therefore my goal in the inline component under Parent Business would be to see list of affiliate businesses (if applicable) AND also see their image… but I do not see option to pull the affiliate business image as there is no such column within the “Affiliate” sheet (and yes - what column and what type of ‘connection’ needs to be created here) – now, moving further --\> after I tap on the affiliate business, their detail list is limited only to the two column in that sheet… my idea here would be to “flow smoothly” – that is, if I tap on an affiliate business (which has all information in the Business sheet) - I would want to see exactly the same “view” of that business as I see under “Businesses” tab – and yes, I understand that I might be certainly missing a point here (which intuitively tells me that the tabs may behave differently and not ‘absorb’ design/layout from another tabs… Hope my stream of thoughts still makes sense 🙂 – thanks for chiming in and helping out!! ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [September 14, 2020, 5:25pm UTC](https://community.glideapps.com/t/relationship-w-affiliates-advise-please/15770/4 "2020-09-14T17:25:31Z")
What you need is a lookup column. Lookup columns work on top of relation columns and capture data for you based on the relation. [https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column) And for the affiliate details page, you need to create a back relation between the affiliate page and the business page and then lookup values from the business page to display those.