J
james_keegan via AccessMonster.com
Hey folks: Stumped again!
I have a data table from my phone switch that looks like this
dn, name, type, keynum, fcode, param
2000, Sally Smith, m2006, 0, scn, 2000
2000, Sally Smith, m2006, 1, trn,
2000, Sally Smith, m2006, 2, cnf,
2000, Sally Smith, m2006, 3, adl, 5252
2001, Joe Schmoe, m2008, 0, scn, 2001
2001, Joe Schmoe, m2008, 1, cnf
What I'm trying to do is to make this into a table that I can index on dn
(dialed number, aka 'extension) so that it looks like this:
dn, name, type, key0code, key0param, key1code, key2code, key2param, ...
key15param
2000, Sally Smith, m2006, scn, 2000, trn, [null],cnf,[null], adl, 5252
2001, Joe Schmoe, m2008, scn, 2001, cnf, [null]
with only one record for each extension.
Is this something I can do without looping through the recordset with VB, and
doing a whole bunch of ifs and creating the records for the new table one by
one? I think I could do this with VB, but I was hoping there was a simpler
way!
Any clues or suggestions?
Or should I abandon the idea, and simply put the keycodes in a 'sub table'
linked by [dn] on a one-to-many basis?
jk
I have a data table from my phone switch that looks like this
dn, name, type, keynum, fcode, param
2000, Sally Smith, m2006, 0, scn, 2000
2000, Sally Smith, m2006, 1, trn,
2000, Sally Smith, m2006, 2, cnf,
2000, Sally Smith, m2006, 3, adl, 5252
2001, Joe Schmoe, m2008, 0, scn, 2001
2001, Joe Schmoe, m2008, 1, cnf
What I'm trying to do is to make this into a table that I can index on dn
(dialed number, aka 'extension) so that it looks like this:
dn, name, type, key0code, key0param, key1code, key2code, key2param, ...
key15param
2000, Sally Smith, m2006, scn, 2000, trn, [null],cnf,[null], adl, 5252
2001, Joe Schmoe, m2008, scn, 2001, cnf, [null]
with only one record for each extension.
Is this something I can do without looping through the recordset with VB, and
doing a whole bunch of ifs and creating the records for the new table one by
one? I think I could do this with VB, but I was hoping there was a simpler
way!
Any clues or suggestions?
Or should I abandon the idea, and simply put the keycodes in a 'sub table'
linked by [dn] on a one-to-many basis?
jk