I have an accounting background, and there is a particular way I prefer keeping track of inventory. I do FIFO, and I want to know the profit for each specific item, so just knowing the total amounts for inventory for COGS and such is insufficient for me. The Inventory itself actually is split up in 4 different tables depending on what "department" it is in. That is not what the table I'm attempting to create does. Yes there are other ways I could record the data, but having a single table recording each individual transaction is the easiest solution as it is incorporated into the custom Register program I am writing. This table is my backup in case something happens and I can trace the transactions for the day and have that data in one record. Or so I hoped. I'm going back through my previous hand recorded sales to see the maximum number of transactions, and though it never has been over 38, I wanted a bigger "margin" than 2 and being able to have 50 unique SKU's in a transaction but I might have to risk limiting it to 40 and go from there.
I appreciate all of the explanations, I believe I understand now what is causing the error. The "too large" error is because of the type of fields and I must have reached the limit. I'm going to see if I changed long text to short text (though i'm not sure if that field then can handle 18 characters) and currency to number if that might allow me to have all 255 fields. We shall see.
Thanks all!
Ken L