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!

You need a line items table - see:

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

Thank you. I think that will work great!