Go to Related record when duplicate

[Anh_Tran]

Dear All,

I have a problem which I could not figure it out how to solve it.

I have a database named A with unique identification Iden_A (calculation (projecno,year) = 1202

I have a database named B with unique identification Iden_B (text) = 1202

Before I go from A to B , I set Iden_b = Iden_A then go to related record since in B there is no Iden_B = 1202 . Is it the correct way to do?

So when I duplicate a record in A ...and I duplicate record in B and when I change A , I can go from A to B which is a duplicate.

Let's say : I duplicate A 1202 and change it to 1204 when I go to B, in B there is 1204 ( which is a duplicate of 1202 of

Sorry my English, If you don't understand I could explain more . For this problem, it take me few months but can not think of a solution with it.

If you have an example to look at, I really appreciate it.

Thanks All

[CobaltSky]

I suggest that you prepare a script in file A which:

1. first determines what the unique ID for the new record will be and writes it to a global field, then

2. uses a "go to related record to locate the corresponding record in file B, then

3. calls an external script in File B which duplicates the related record and writes the new unique ID (sourced from the global field) to the Iden_B field in the new record in B.

4. Finally your script in File A can continue and duplicate the record in File A

5. The the script in File A can write the value from the global field to Iden_A

6. Finally, the global field value can be cleared.

Does that answer your question?

[Anh_Tran]

I will try later

Thanks ...your idea gives me a huge hint for my problem.

[Anh_Tran]

Dear Cobaltsky,

If i have a database A with unique identification Iden_A = 1020 then I go to related record in B , Iden_B = 1020

If i change Iden_A = 1029 , can it go to B , Iden_B =1029( which is same as 1020 of :

Please help me with this idea

I am really lost.

Thanks