Finance | Project Operations, Human Resources, ...

How to make form open on specific record?

(0) Share

Report

Posted on by CSafwat

I have two forms FormA and FormB, when open FormB from FormA the cursor always points to the first record. I want to make the cursor of FormB points to the record related with FormA.

I tried tableB_ds.positionToRecord(record) but it is not working. I also tried tableB_ds.findRecord(_record) and none of them worked with me.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi CSafwat,

Please check this thread. It answers a question similar to the one you have.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi CSafwat,

Usually, you can achieve this behavior by implementing a relation between the caller table on FormA and the root table on FormB. Do you have this kind of relations between tables?

Was this reply helpful? Yes No
CSafwat 90 on at

Like (0)

Report

Hi Gunjan,

I can't use this solution as it's not the main datasource of the Form.

Was this reply helpful? Yes No
CSafwat 90 on at

Like (0)

Report

Hi Sergei,

actually they have relation but the problem is tableA in FormA have relation with tableB in FormB but tableB is not the main datasource of FormB. so, I am trying to make the cursor of tableB points to the correct position. whenI used tableB_ds.findRecord(_record) the cursor gets the right record but when the form opened the cursor returned to the first record.

Was this reply helpful? Yes No
Ranjeet_Kr on at

Like (0)

Report

Hi,

Could you please help us with the complete scenario to test this behavior in standard environment.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

If it's the main data source, you'll get a dynamic link automatically, but you can explictiyl use addDynalink to add it to a different data source (and let the standard logic do the rest).

I used this technique in DataReferenceSearcher, therefore you can look at a concrete example there.

Was this reply helpful? Yes No
CSafwat 90 on at

Like (0)

Report

Thank you all.

I solved the problem by using tableB_ds.positionToRecord(record) but calling it in linkActive() method of the form datasource.

Was this reply helpful? Yes No