2 Replies Latest reply on Sep 30, 2010 10:27 AM by AntonChuykin

    I need your suggestions for purchase order portal table

    AntonChuykin

      Title

      I need your suggestions for purchase order portal table

      Post

      Dear friends,

      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:

      table

      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!