Invoice Disaster -- MySQL Guru, FM N00b

[Aviosity]

Hello all!

I've been working with MySQL for over a year now, and it works great for the online development I do a lot. But now, I've been contracted by a major research institution to do database work in FMP7. I've never used FMP before, and have been teaching it to myself over the past week while trying to complete this invoice.

This invoicing system has the following requirements:

1) Needs to be able to place 4 different products with 4 different quantities on the invoice, preferably with a single drop down menu for the product (with a value list linked to the products table), a single numeric edit field for the quantity, and a "add product" button so that the first time they enter a product it will go into slot 1, the second time slot 2, etc.

2) Needs to keep a record of all sales made, containing the date of sale, sale/invoice ID, products sold, quantity of each product sold, total amount of sale, shipping/handling and client ID. This record needs to be browsable and searchable by product name, sale ID, and client name.

3) Needs to be able to add new clients and new products.

OK, so here's where I am so far. I have 3 tables -- Products, Clients, and Sales. The products and clients tables work beautifully; I can add, delete, edit, and find products and clients easily. The actual invoice itself is a disaster. I've got a drop-down box that selects the client, and a portal to the client table that imports the client's shipping and billing information. That works fine, but listing the products has taken me 2 days now of failed attempts. Also, getting the data saved as a sale has seemed impossible.

Any help you folks could give me would be great. I have a feeling I'll be hanging around here a lot more in the weeks to come

[Reed]

Check out Filemaker Business Tracker on filemaker.com..... it is a free download and it is unlocked so you can see how it works.

Dana

[Aviosity]

Dana: This looks great. Thanks for your help!