Hi All, I'm working on a similar issue. I am trying to join two data sources together using the card number in both tables to show which loyalty program name that card number is associated to. I have been using filter and the lookup function but I'm still having no luck. I am trying to display the field "loyaltyprogramname" in a label box.
Below are the two tables.
RetailLoyaltycards: Card Number
RetailLoyaltyCardTiers: Card Number , Loyalty Program Name
Any help would be greatly appreciated!
I have used the expression to populate the Data Table and I am successful in doing it for 2 tables ( 1 Main Table and 1 Look u Table). There is one more column in main table which i want to lookup in another secondary table.
How to do that? Pls guide.