>Or better yet, bite the bullet now, and create a customers table and a transactions table with a one to many relationship between them, and a unique id to link them together ;)

Todd,

As someone once said, "It will never be easier to fix it than it is right now."
:-)