Hi
Firstly I would like to say I am new to Access, so I don't know all the terminology.
Can't describe exactly what I'm trying to achieve here, so, in a nutshell, I want know if there is any way I can automate the creation Table 2 from Table 1:
Table
1
Customer Product
1 A,C
2 A,B,C,D
3 A,D
Table
2
Customer Product
1 A
1 C
2 A
2 B
2 C
2 D
3 A
3 D
Thanks in advance for your help.
Regards
Vik
Firstly I would like to say I am new to Access, so I don't know all the terminology.
Can't describe exactly what I'm trying to achieve here, so, in a nutshell, I want know if there is any way I can automate the creation Table 2 from Table 1:
Table
1
Customer Product
1 A,C
2 A,B,C,D
3 A,D
Table
2
Customer Product
1 A
1 C
2 A
2 B
2 C
2 D
3 A
3 D
Thanks in advance for your help.
Regards
Vik