create records from value list

[whitehouse]

Hi,

I currently have a database with a value list in it. This list gets a client_ID added to it via a relationship with another database. Every time a Client_ID with a type of "PW" gets added to the related DB, the value list in the file I am working on gets that Client_ID added to it. This part works fine.

Now, what I would like to happen is have a record created in the database with the value list for each client_ID, with the value auto entered into the CID field. Currently there are 43 client_ID's in the list, so I would need 43 records. However if a 44th gets added via the previously mentioned relationship, it should automatically add a 44th record with the new client_ID of the value list entered into the CID field.

any ideas on how to go about this? can it be automated, or would a script that I call work better?

thanks in advance