Lookup Issue

starquest321 · Post by **starquest321** » Sun Oct 13, 2013 12:21 am

I have the following table setup:

index
table_name
fields
users
userid

In table_name I put in the name of a table in my database. I want then based on lookup to get all the fields related to that table so I can select them. How can I do that? I manual type the name of the table in table_name

mobhar · Post by **mobhar** » Sun Oct 13, 2013 1:33 pm

Your post is not clear enough. An example of use case would be better to understand.

However, this will list all the fields based on the table_name parameter: SELECT fields FROM yourtable WHERE table_name = 'xxx'

starquest321 · Post by **starquest321** » Mon Oct 14, 2013 3:27 am

My table stores fields which needs to be hidden based on table selected. But I don't know how I can enter a drop down selection of all tables in my database inclluding the views ---> from which I can generate parent child relationship of all fields based on a table. Your suggestion above is good ---> where can I put it?

mobhar · Post by **mobhar** » Mon Oct 14, 2013 10:21 am

I suggest you to create the "Master" and "Detail" tables for this. For example:

Master table/view: "table_permissions", which has the field (at least) as follow:

table_name

Please note that you can create a View for the master table above using the detail table below which contain only one field by using this SQL: "SELECT DISTINCT table_name FROM field_permissions"

Detail table: "field_permissions", which has the fields (at least) as follow:

table_name
field_name
users
userid

So, if you want to manage the which field(s) should be hidden for the certain users, then you can create a Master/Detail relationship for those tables.