September 11, 200718 yr I have an invoice table and a bin table. The bin table have 700 records from 1001 - 1700. What I need is when I create a new invoice, FM would automatically assign the next available bin number to that invoice. And that bin number won't be available to any invoice until that invoice has been cleared. The logic sounds simple but I'm not sure how to do it in FM. Thanks.
September 11, 200718 yr Seems very similar to this: http://www.fmforums.com/forum/showtopic.php?tid/186968/
Create an account or sign in to comment