datasetup.jpg
what about something like this
so every possible value can be accounted for in one row per customer?
2 (or more) values for Acct, 2 shipto, 2 billto, 2pricing per 3 types, etcs
that way you can populate as much as is needed