Number and Re-Number Portal Rows
We use FMP 12 with FileMaker Server.
We have a Quotations file with a related Quotations Lines file. The system has been working great for thousands of Quotes over many years. We'd like to do the following and I can't figure out how:
1. Have each new Line, upon creation, display a Line Number starting with 10 and incrementing by 10 to 20, 30, etc. I would set the Portal to Sort by Line Number.
2. Each new Quotation starts with Line Number 10 and increments by 10 to 20, 30 etc.
3. Allow the User to easily change any Line Number thereby re-ordering the Line Items on the fly. For example: In a Quotations with 12 lines, the User can edit the Line Number of the the last line (Line Number 120) to perhaps “11” thereby placing it between Line Number 10 and Line Number 20.
Any help will be greatly appreciated.