I would like to know how to generate a table of unique part numbers in access using the following template:
ABC-DE
where possible entries for each letter are:
A=1,2,3,4,5
B=CD,ER,FF,FE
C=A,B
D=43,23,12
E=1,11,111,1111
A sample part number would be 1CDA-431. What is the best way of...