Filemaker novice with a serious problem. I have auto-enter five digit serial numbers. I need to create a script that appends dash 1, dash 2, and so on... Ex: 89632, 89632-1, 89632-2... I'm completely stumped. Any help would be greatly appreciated. Many thanks in advance.

... what?... why?... more details or its hard to help...

Thanks for the offer. I currently generate a record with an auto-entered serial number (xxxx). I need to duplicate that record and attach a serial number that is a sub-set of the original serial number (xxxx-1). I'd like to repeat this process: xxxx-2, xxxx-3, xxxx-4, etc. Hope that helps.

ok... ummm. still a bit confused... how many records... if you want you just run a script like ummm... and lets say duplicate 10 times...therefore generating up to 10 records with sub serials... no idea why but hey...

SetVariable(ID = Serial Number)

SetVariable(RecordGenNo = 1)

Loop

- Duplicate Record

- Set Field (ID) = ID & "-" & RecordGenNo

- SetVariable(RecordGenNo = RecordGenNo + 1)

- Exit Loop If RecordGenNo = 11

- Goto Record Next

End Loop...

I highly doubt this is what you wanted... but hey

Edited January 24, 200620 yr by Guest

Thanks so much for the help. I'll give it a try. Sorry I'm not more clear. We're doing jobs that occur in stages with different assets. We'd like to complete stage one of a job, then reassign people and proceed on to a second phase, etc. Thanks again.

Hi RK

I think that it's possible to make a calculated serial number with a flag (1 or 0 as default), so that if you want a duplicate, you'll set the flag to 1:

1 (flag to 0)

2 (flag to 0)

3-1 (flag to 1)

3-2 (flag to 1)

4 (flag to 0)

and so on...

Is this what you wish ?

See the demos on the Nightwing web site

http://www.nightwing.com.au/FileMaker/