Generate Lines

wunderch — Thu, 28 Feb 2013 09:46:49 GMT

Hello,

I have the following problem:

I have 2 tables:

First

Second

User "Tom" have the access for Store 100, 115, 185.

User "Pual" have the access for alle Stores where listed in the second table.

So in the End i need a table that looks like this:

I need something like this:

if(Store='***', 'take all Stores from Second Table) as Store

Any ideas??

Regards

Chris

Re: Generate Lines

Gysbert_Wassenaar — Thu, 28 Feb 2013 10:09:40 GMT

See attached qvw

wunderch — Thu, 28 Feb 2013 10:27:06 GMT

Thanks for your quick answer!

It works great!