set field and insert calculated result functions in scripts failing

[Twd70]

this is pretty disasterous.

I had a db that was related like this:

table Client Job job data

key Client name Job Number job number

contains: client name

this worked fine. all scripts were fine...untill i was told that the job needed to be automatically created (even though they insisted they wanted to manually input it when i asked pre-start)

so now:

client gets an auto no on create (client no). a job when created gets its own auto created suffix (job suffix). these 2 hyphonated (concatenated) give me a job number. however to keep the relationships strong client no and job suffix are the keys throughout and define a job and job data.

job - job data is 1-1 and unique.

client - job is 1-many.

so the relationships seem fine if i input the data into 'job data' myself (jus the client no + suffix) then everything else pops up through calculated results.

but:

since i did this i can no longer use SetField or Insert calculated result.

i can copy and paste 1 item but thats not practical when i need both fields copied across to create a new 'job data' record.

please help.

Many thanks

[Twd70]

after a little playing about i think its becuase the fields are key fields.

so what function do people use to create a new record and move the key field over? or is there something else?

[Inky Phil]

If no related child records exist all you have to do is set a field in the related table and that will create the new record and move the key in automatically.

If other related child records already exist then script the creation of a new child record and move the key across with a script parameter or a global if the tables are in the same file

HTH

Phil

[Lee Smith]

Please do [color:red] Not double post in the Forum.

I have deleted your other Thread with the same subject name.

Lee