I need your suggestions for purchase order portal table
I'm trying to establish database to issue purchase orders for my business. I have two problems that I can't figure out:
1. Primary one: I need to make a table with goods description: size, thickness, quantity, price, etc. From one PO to another amount of positions (rows) may vary from 1 to 10 maximum. Is it possible with filemaker and it's portal setup to make row amount flexible to hide unused lines? I found here, that I can make portal borders transperent, but I want to have TOTAL AMOUNT just under my table for each column (quantity, amount, etc) like this:
How would you do this?
2. Secondary: I want my PO number counter to have a mask like "xxx-10" (ex 063-10), where xxx is order's number ascending and 10 is current year. Is it possible?
Thank you beforehand for you time and help!