sourcing field for another field

[siculster]

Hi,

I have a text field (field1) which takes data in the following format:


S75-24-185-140

But i wish to have another field which creates an invoice number (field2) based on the 185 part but also combines autonumber eg:

185xxx

with xxx incrementing from 1 to 999

Maybe i havent explained this well, but are there any ideas??

Thanks

 

[Captain Chaos]

I'm not aware that you can do much with an autonumber field. You will have to keep the field1("185") and sequence number separate and concatenate them in queries
i.e. field1 & format(autonumberfield,"000") would give you '185001'