Indexing a number

[Ben Ball]

I have a layout that creates a new record ID everytime a new record is created. Naturally.

I have a layout which is based on the same table where I have another form. I do not wish to give this layout the same ID number as the main layout number.

I have a button which will take me to layout 2 and what I need this button to do is is find the last number entered when the button was pressed and input that unique ID.

I have thought about introducing a global field, setting the field to the say 0001 +1 and then setting the solid field to the value in the global field. This would give me a unique value but I do not feel that this method is "Robust"?Does anyone have any other options?

[Vaughan]

the global field trechnique won't work in multi-user, but putting it into a field in a prefs table will get around that.

However, I have no idea why something like this would be necessary. Tell us more about what your are trying to achieve, rather than how you want to do it.

[Ben Ball]

What I have is main jobs page where I have line items through a portal. In some cases I wish to use the same layout to send line items out for tender. Instead of creating a new table links etc it would be advantageous for me to duplicate the layout create a new form for tender/quotation with a unique ID which is directly related to the main order.

I don't want the quoteID to be the same as my main ID. and I only want it to be commited when I print off a quote sheet. It will save me time in designing a layout/form and save time in updating records.