I'm not sure how to do this

[jrie818]

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.

[comment]

Seems very similar to this:

http://www.fmforums.com/forum/showtopic.php?tid/186968/