# Carry related info between tables **URL:** \ **Category:** Ask for Help\ **Created:** [June 2, 2022, 9:20pm UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676 "2022-06-02T21:20:34Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![fluittsolutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fluittsolutions/32/30155_2.png) [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)\ **Post date:** [June 2, 2022, 9:20pm UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/1 "2022-06-02T21:20:34Z")
Hello, Gliders, I’m working on my membership tracking page for nonprofits. I have built two sheets as follows: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/1278957ea03f7bb26710e7a4e413d1e730236cc9.png) I successfully identified the most recent gift for each member in order to calculate the membership expiration date (MATH column of "Most recent gift date + 365). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e390425b3138aebe6ab8239553206738666da0c7.png) Now I need to bring the current membership level into the Member table AND be able to filter on it. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf4849748700a52d9531a44ccd19b416c9f92295.png) - Tried ROLLUP - failed because member level field isn’t date or number. - Tried LOOKUP - failed because it returned the array of all payments–can’t identify and isolate the last payment. I welcome suggestions on how to identify and return the _current_ member level based on last payment amount. Whatever that resulting field is also needs to be accessible in a SINGLE VALUE and IF/THEN field for filtering through a choice component. Thank you for helping with this puzzle. Mona ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 2, 2022, 9:31pm UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/2 "2022-06-02T21:31:18Z")
Probably easiest way is to do a multiple relation of users to gifts and then use a single value column to grab the last item from the relation (given that the sheet is sorted in chronological order). ---
**Author:** ![fluittsolutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fluittsolutions/32/30155_2.png) [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)\ **Post date:** [June 2, 2022, 10:02pm UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/3 "2022-06-02T22:02:44Z")
As I was composing my post, I was thinking @Robert_Petitto would know what to do. I didn’t follow your suggestion exactly because I don’t have a same-table relation to build to fit this scenario., However, your response inspired this: Member Payments Table: Create IF/THEN column that returned Member Level name based on payment amount–Friend, Sponsor, Patron, Benefactor. Member Table: Created SINGLE VALUE column of Get Last from (TABLE) Member Payments (COLUMN) Member Level of each payment. This resulted in each unique Member row having the correct current member level. _ **This is what I couldn’t accomplish before.** _ Then the multi-filter system I learned from you worked perfectly in the Member Table: - TEXT ENTRY column to select filter option - SINGLE VALUE column of Get First from TEXT ENTRY column - IF/THEN column IF SINGLE VALUE current member level = SINGLE VALUE filter selection THEN true. Thank you, @Robert_Petitto. Wish I had just asked you 24 hours ago. ---
**Author:** ![justinjmp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justinjmp/32/43205_2.png) [@justinjmp](https://community.glideapps.com/u/justinjmp)\ **Post date:** [June 2, 2022, 10:09pm UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/4 "2022-06-02T22:09:56Z")
@Robert_Petitto always knows what to do! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 2, 2022, 10:31pm UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/5 "2022-06-02T22:31:20Z")
Not always, but when I do, I’m glad others can benefit. …seems like a Dos Equis meme waiting to happen… ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [June 3, 2022, 1:04am UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/6 "2022-06-03T01:04:34Z")
> [@Robert\_Petitto](#): > > Not always, but when I do, I’m glad others can benefit. ![The-Most-Interesting-Man-In-The-World](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/71fce66a8d607f63f82e89a4f50f6b746ceb2bad.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 3, 2022, 1:49am UTC](https://community.glideapps.com/t/carry-related-info-between-tables/42676/7 "2022-06-03T01:49:26Z")
🤣