Order Details Pricing

What is your table structure? Field names and datatype.

"Jim P - MA" wrote:

I have an application that seems to be unusual in that for each product
record, I would like the ability to store differing Quantity, Pricing, and
Special Notes to later appear in a Combo Box for users to enter the proper
price from the list. Any suggestions on how this would best be
accomplished? The pricing data is currently stored in the record rows as
Q1, P1, Q2, P2 etc. How do I convert these rows to a usable table or query
to feed the Combo Box during Order Detail entry by user?

Any help or direction would be GREATLY appreciated!

Thank you,
Jim Pond