File insert into new record

[SilverReed]

Hi Guys,

I have tried different solutions but without the luck.

Here is my problem.

I do have the database on the server (FMS) and I am using the FMP for accessing the database.

I have the table with the following structure:

Specifications TABLE

1. Name TEXT FIELD

2. Spec code TEXT FIELD

3. Doc file CONTAINER FIELD

now:

I have the file 0.doc on the server in the same folder as the database file.

I would like to make some solution to:

1. When I insert the text to the Spec code TEXT FIELD

2. The script copy the file 0.doc to the new one with the name: (Spec code TEXT FIELD).doc

3. The script insert the (Spec code TEXT FIELD).doc into Doc file CONTAINER FIELD

is it possible to be made?

what I can do is export / import the file from the filed to my local computer, but what if the file is more than 5mb of size? it would last a looong time.

Can you advice?

Many thanks.

Luca