Generate Lines

[wunderch]

Hello,

I have the following problem:

I have 2 tables:

First

Store	User
100	Tom
115	Tom
185	Tom
***	Paul

Second

Store
100
108
109
115
118
119
130
170
185

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:

Store	User
100	Tom
115	Tom
185	Tom
100	Paul
108	Paul
109	Paul
115	Paul
118	Paul
119	Paul
130	Paul
170	Paul
185	Paul

I need something like this:

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

Any ideas??

Regards

Chris

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[wunderch]

Thanks for your quick answer!

It works great!