Hello. I'm in the process of designing a database that keeps track of inventory and clients. As inventory is tracked through the database, I thought it would be easy to add an estimate layout where I can create an invoice (so to speak) for a client. Essentially what I want is, once creating a new record, a portal which let's me choose the product or item id number and for the details to appear in the portal row (manufacturer, price, etc (all from the inventory table)) and to then advance to the next row so I can repeat the process over and essentially create a receipt. A similar method was discussed here for creating recipes, but that uses multiple tables. I would like to know what additional tables I will have to make and what type of relationships I will need to create to make it work the way I want. I've tried to dissect the example database posted in the thread above but it seems a bit complicated.

I'm still a newbie so thanks for any help you can give me and I hope I explained myself well enough.

Btw - I'm using FMP9 Advanced on a Windows Vista machine.

Well, since I recently addressed really the same thing and provided a sample file, see if it will help you as well here . It also has adding products into a portal.

Thanks LaRetta! Should've looked harder myself.