copying a record to another data file

#63960 - 04/18/03 12:39 AM Edit Reply Quote Quick Reply

I have created 2 different data files:

<***> = a button to edit field

(***) = the field

heres what they look like:

#1

COMPLAINT FORM

<Complaint#> (5477)

<Date> (4/12/03)

<customer#> (131316)

<customer name> (John Doe Co.)

<address> (576 East Ave.)

<complaint> (discription)

<date recieved> (4/11/03)

<send Info to new investigation form>

#2

INVESTIGATION FORM

<inestigation results> (type in details)

<date> (date)

<performed By> (john doe)

<close investigation>

And here is what I want to do:

I want to be able to fill out the first form, and when Im done push the <send info to investigation form> button and it runs a script that will copy the entire currtent record with the buttons and the field info exactly the way it appears in the complaint form and paste it in the top portion of the investigation form in a new Investigation form record. (minus the <send info to investigation> button)

In the new investigation report form record:

-I do not want modification to be allowed to any of what was copied and pasted from the complaint form record.

-Want to only allow users with permission to access the new record and fill in the investigation information.

-delete original complaint information record.

the result looking like this after the the complaint form <send info to invest.> button is pushed:

COMPLAINT FORM

<Complaint#> (5477)

<Date> (4/12/03)

<customer#> (131316)

<customer name> (John Doe Co.)

<address> (576 East Ave.)

<complaint> (discription)

<date recieved> (4/11/03)

<send Info to new investigation form>

INVESTIGATION FORM

<inestigation results> (type in details)

<date> (date)

<performed By> (john doe)

<close investigation>

Is this possible and if so can someone tell me how in a decient amount of detail. My brain is about to pop trying to figure this out. Would a script be the best way to do this.

also : there are no relationships defined or anthing else other than the fields and buttons being defined. I just have the visual look made and the format of each file made up.

Should I define any relationships if so which ones and how.

Any information would be greatly appreciated.

thank you in advance

Josh

DUPLICATE POST!!!

Never post anything twice.