Copying a related record?

Classic Servoy
1

Can anyone tell me what would be the best method to copy the complete content of a related record into the current record?

Would that be field by field or can this be done any smarter?

2

Hi Marcel,

Have you thought about :

  1. Isolate the related record export as tab or comma and then import it.
  2. Use the controller.copyrecord command to capture the record tab delimited and then parse the data into the master record.
  3. capture the serial_id of the related record and set that value into a global field in the master record to force a relookup of the data via relationship from global serial id to related serial id

Harry

3

Hai Harry,

Thanks for guiding me with my thoughtprocess. Here are my thoughts so far:

  1. I don’t like this. Looks like a too intensive/timeconsuming task…
  2. This was my first thought but… When working with a related record (the one I want to copy) this copyrecord is not available.
  3. Can you give me more details or an example? I don’t think (or I am sure :lol: ) that I understand what you mean…
4

For point 3) I assume that your related record has a unique serial id field.

If you capture the serial id of the related record from which you wish to move the field data you can then place that serial id value into a field within the master file.

If you have a relationship from that field in the master file to the serial id field in the related file then you have a link directly to the data that you wish to capture and move.

If you set the fields in the master file to have auto enter properties then you can run a relookup function (controller.relookup) based upon the relationship between master and related record set up above, which will lookup the data automatically for you.

Does this make sense ?

5

Ah, ok now I understand. I will try this tomorrow… Thanks

6

I haven’t tried this, but I imagine you could also do a direct query with the database manager, pushing the result into your main record.

7

This was my first idea too but I don’t like to go over all fields one by one and at the same time check it the fields correspond. Apart from the programming I will have to check appr. 7 records per go. I think this will take too much time.

8

Harry thanks,

At least for the (initial) making of the record this works…
I will now see if your tip works when the record already exists…