Each record in my table (called Brooks) is a separate order. Each order/record includes a store number, as well as a bunch of name fields (name1, name2, name3, etc).
The idea is that a store can enter a bunch of names into the table and we can process an order (each record).
I would like to be...