Hi all

this is my first post.

can anyone suggest how to solve a problem

I have two related tables. The first has a data in which one of the fields is a category. The second has a global which can be altered to permitt viewing only data of that category.

My question is, how can I set this up to electively see ALL the categories

Well something like this - but you have to get the terminology right here, there is here in this solution only one table, two table occurances an one selfjoin relation!

So how does your statement:

I have two related tables

...fit into the equation, to have this as a completed action??

------------------------------------------------------

Well just after posting the first template, did I reread the header of the post ...and it could be interpreted the way the second upload exhibits...

--sd

pling.zip

plang.zip

Thanks for your reply.

What I meant is that in your example, how can I show all the values in the portal at once. i.e all the values for vehicle, tool and nation by having a popup fileld with the option of show all

Joseph

Well it could be done with calcfields utilizing ValuelistItems( but at this day of age would I not hessitate doing this instead:

--sd

dong.zip