Hey team! Here's my current "hmmmm...how can I do that?" scenario. I'd like to see if I have any decent idea how to do it before starting to create something that may or may not work.

I want to my user to be able to have the last generated job record number appear in a pop-up window or list when they are creating a new job record so they can determine the next job number to assign without having to leave the record they are in. (And, no, the job record numbers cannot be a auto-generated serial numbers in case you're wonder. That would be too easy.)

So my theory is to have the client code that the user just entered be copied into a search field and a find be generated showing the last number used with that client code in a (global?) field in a separate pop-up window.

Does this make any sense to try to pursue or am I missing an obvious way to accomplish this? If I am at all on the right track, how do I proceed? With a separate table? If so, what kind of relationship? What scripting steps might I need?

Come on creative genius'. I know you're out there!

Thanks

Does this make any sense

.....Not quite!

Make a related dynamic valuelist on ClientID is pretty straight forward ...is the popup not to be used but instead ment as a guidance to provide appropriate spacing for the new jobnumber???

Otherwise is it just to Lookup Next Lower( ...that will keep the previous one until altered, because it seems weird to have a popup just containing one value?:

--sd