Database/List Manipulation

[DarinM]

re post #18
maybe add an if statement in the loop so If account doesn't match but address does, combine those ?

they would have to be in separate columns, can't combine...the filter search would be useless, it would be 00000-xxx00000-xxx.
it would have to check against itself I guess and then add into the next open pricing slot, if duplicates.

please see attached, that is a direct export, got rid of some content but left the columns as it really would be

also to note, we have 49 pricing codes, but only 5 are frequently used, so once we get this going, I would add the remainder on the end of the columns for the rare use that they would show up. wont worry about that.