Hi there @Steven_May! Sounds like you want to add a junction table.
This is definitely one of the more difficult concepts to wrap your head around when it comes to database structure. In essence, you have a many-to-many relationship between customers and items purchased. One customer can buy many types of items, and one type of item can be sold to many customers.
You’ll want to add a table that’s linked to your customers, as well as to the produce table, probably called something like [Purchases] or [Line Items]. Each record should be associated with one item, and one customer. Here is where you can put the weights and quantities of the produce purchased.
You might also want to add another table, called something like [Orders]. If Ms. Smith buys 3 pounds of apples and 2.27 lbs of bananas in one purchase, ideally this would be represented by 2 records on the [Line Items] table, one for apples, and one for bananas. Both of these records could be linked to a record on the [Orders] table, where for example, you can sum up the total cost for that particular order.
Here’s an example base I made that might help to support what I’m trying to explain… it’s regarding invoices and line items, but the concept is the same. Hope this helps!