Listing of items

[design1990]

Okay, so I've looked through various questions and can't really find the answer to mine. The problem though is that I'm not fully literate in FM-speak so please bear with me.

I have a business where I sell different items. I've set up a database to record all the customer info including the items sold. Here's what I'm having trouble figuring out:

When a customer buys 3 of Item A and 2 of Item B, I want to be able to indicate the quantity next to that item. However, I can't figure out how to get a list of the 50 items that I sell into a field. All I can think of to do is to have an individual field name for each item that I could put the quantity into. I'm sure there's something that links tables, etc., but I'm not able to figure it out.

Any help would be greatly appreciated.

Thanks so much!

[comment]

You need a line items table - see:

http://fmforums.com/forum/showpost.php?post/309136/

[design1990]

Thank you. I think that will work great!