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.