I have a relation column in users table that relates subscriptions. In the subscription table, there is a relation column that relates subscription plans. I am trying to do a lookup in users table which will pull user_limit which is a column in subscription plans. Lookup - relation to subscription - relation to plan - user-limit. The columns list in Relation to Plan (subscription plans) does not show.
Assuming âRelation to planâ is a SINLGLE relation add a lookup colum to you subscription table via ârelation to planâ and select the column you want to bring in.
Now when you go through the ârelation to subscriptionâ list you should see the new look up column.
That worked nicely. Thanks a lot.
1 Like