Totally unsure - Tech Challenge

[uzy]

Hi

I have recently start to use Access and trying to figure out how to
solve the following problem, moreover, if it is even possible to do it
in Access.

Any ideas would be greatly appreciated.

Many thanks
Uzy

I have a table called MASTER which tells me how each row is dimensioned
by. I need to read this information and devise the permutations based
on DIM1 and DIM2. So the four records in MASTER would be turned to nine
records as seen in the RESULTS table.

MASTER
ID1 DIM1 DIM2
harry
peter x x
taz x
uzy x

DIM1
key label
1 phone
2 memory

DIM2
pkey plabel
p1 nokia
p2 sony

The result table I want is as follows:
RESULT

ID1 key label pkey plabel
harry
peter 1 phone p1 nokia
peter 1 phone p2 sony
peter 2 memory p1 nokia
peter 2 memory p2 sony
taz p1 nokia
taz p2 sony
uzy 1 phone
uzy 2 memory

 

[Guest]

I'm not sure what you are trying to do, but I'm very sure Access is the wrong
tool.

 

[uzy]

Thanks for the comment but it dont help! I basically want to produce
cartesian joins where there is "x" under a DIM table. This is quite
easy, the trick is to do it all in one query where ID1 is also
displayed.