13 posts in this topic
By Ben Moore
Often we have to revise estimates for a customer, and they may come back and order against an estimate that is not the most recent. I am trying to find the best way to tie all the estimates together with the same Estimate or Job #, and increment a revision #. So far I've created a Job# field, and a Revision number field, but having trouble getting the revision number and job number to increment correctly when I have a new estimate vs a revision. Any suggestions?
By Matthew R White
I have a number field that I would like to auto enter either (2, 3, or 9) at random every time a new record is created.
I tried to do a sequenced auto enter but filemaker simply counts up from 1 and I can't specify the 3 numbers.