>why don't you use a single parameterize view?
>e.g.
>CREATE SQL .. SELECT... where Codetype=?tCodeType

>why not create a view on your original "Master" and "data" tables that will give you the final resultset
>why do you create an intermidiate view and then try to index and relate views?

Arnon,

I was creating the 'middle' views since I have multiple fields in each data table record which each need to look up codeno's (unique key values) from my single 'codes' table for individual columns in my grids. Eg: the data table contains a field "appletypecode" which needs to relate to codetable.codeno to then display the appropriate codetable.displayvalue, a "orangetypecode" field which needs to again relate to codetable.codeno to then display the appropriate codetable.displayvalue, etc.

Plus I need combo boxes for specific codetypes to display for clicks in several columns in each grid. eg: column1 displays appletype, and when the cell is clicked, the list of available apple types show up should the user want to change the apple type, and so on for "oranges", "bananas" etc.

Make sense???

Mandy