Good day everyone, I am new to FileMaker. I am in the process of making or trying to make a database that will allow me to enter paid invoices for a company. It would have supplier info, product info, dept purchased for info and the ability to key the paid invoice as an invoice. That is the part I'm stuck on. I think I need to create a portal on my invoice table, and I was thinking to have it pull data from the products table and then add qtys and subtotals. However it doesn't seem to work that way. I am now thinking after reviewing the solution starter on invoices that I need an additional table for line items. And that the portal in essence would be entering the data vicariously into the line item table as the invoice table so to speak cannot handle that info as I am wanting to enter it.
Example the portal would let you enter 10 separate parts with product # price and description and then sub total the whole as your entering data. And I would be able to retrieve that invoice from that supplier by rolling through the records later and such.
If anyone out there is able to point me in the right direction I'd certainly appreciate the advise.
Thanks very much
Brian