I have a FM db that creates medical claims for insurance and I need to create a duplicate claim while creating a new record #. My record # is calculated based on the date, time record ######-######-######. How can I duplicate the record but generate a new record #?

Dear Kensey S.

Sounds easy, buy maybe I don't understand your question fully...

Say you've got three fields:

date -> auto inserted calculated value, status(currentdate)

time-> auto inserted calculated value, status(currenttime)

serialn

Ernst:

It should be the other way around. Kensey wants a new record ID when a record is duplicated.

So, you do want to use the auto-enter date, time & serial number in 3 separate fields and then combine them in one calculated field. Or, use scripts for record creation and duplication, so that you can manage the record numbers more securely with a Captkurt style unique ID.

Hey Bob and Kensey,

It was not totally clear to me what Kensey actually wants, I interpreted his task as trying to generate a serial number that has the original date and time of entry but a unique serialn

This is Cpt Kurt's serial number generator. so I need to duplicate the current file and regenerate a new serial number. If i just duplicate the current record I will also have duplicate serial numbers.

Sorry, duplicate the record.

Now how do I generae a new SN?

Thanks. I think I figured it out.

I created a script using SetField and regenerated the SN and inserted the script into the other script that duplicated the file. Now I can duplicate the file and create a new SN for the duplicated file. I will have to restructure my claim file to have the line items within the actual record instead of linking to a lineItems file. Generating a new sn breaks the link to the original line items.