Smith, thanks for the response, its and idea but i have 104 columns and 32 tables

user might select from any of those columns so its not that easy to populate all those and hide the remaining as the join itself might take so long to execute