All,
Is it possible to break a single record into many records within a single table?
For example,
AcctNumb Note1 Note2 Note3 Note4
1234 xxxxx yyyyy zzzzz vvvvv
1235 xxxxx yyyyy zzzzz vvvvv
So it would look like:
1234 xxxxx
1234 yyyyy
1234 zzzzz
1234 vvvvv
1235 xxxxx
1235 yyyyy
1235 zzzzz
1235 vvvvv
Thanks
Rob
Is it possible to break a single record into many records within a single table?
For example,
AcctNumb Note1 Note2 Note3 Note4
1234 xxxxx yyyyy zzzzz vvvvv
1235 xxxxx yyyyy zzzzz vvvvv
So it would look like:
1234 xxxxx
1234 yyyyy
1234 zzzzz
1234 vvvvv
1235 xxxxx
1235 yyyyy
1235 zzzzz
1235 vvvvv
Thanks
Rob