Finance | Project Operations, Human Resources, ...

getting data from two different tables through the args class

(0) Share

Report

Posted on by Kareem Taima

Hi,

I have a grid that displays data from two different tables, I'm using the args class to pass the data to another form and it works for just one table but I can't get the other data table, I tired to use select statements but just keep getting me the same value

I have the same question (0)

All responses (6)

Answers (0)

Kareem Taima 45 on at

Like (0)

Report

RE: getting data from two different tables through the args class

thanks

I'll try it

Was this reply helpful? Yes No
Kareem Taima 45 on at

Like (0)

Report

RE: getting data from two different tables through the args class

thank you a lot

it's big help

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 235,792 Most Valuable Professional on at

Like (1)

Report

RE: getting data from two different tables through the args class

The best option may be using relatedTable() method. You can see an example in CustTable.name().

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

RE: getting data from two different tables through the args class

You can pass only one table buffer via args.record().

But if you pass SalesAgreementLine, you always know how to fetch SalesAgreementTable, right?

Or, if you pass SalesAgreementTable, you can iterate all lines in code.

But, you can also user args.caller() to get the whole FormRun object of the caller form. Via FormRun you can access any object on the caller form. Including active records in all data sources.

Was this reply helpful? Yes No
Kareem Taima 45 on at

Like (0)

Report

RE: getting data from two different tables through the args class

Hi André ,

I have a grid in FormA it has data from SalesAgreement table and AgreementLine table, when I select line and press buttonOpenFormB I need to have the data in the record from both table, but I only managed to get the data from SalesAgreement table using args class, I couldn't get AgreementLine table data in FormB.. I managed to get the data using select statement between AgreementLine and SalesAgreement, I don't know if you can do it through args class or I'm just dreaming :D

thank anyway

Was this reply helpful? Yes No
André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (1)

Report

RE: getting data from two different tables through the args class

Hi Kareem,

Can you provide more information? What exact tables are used on the first form and what should be the result when you start the second form?

Was this reply helpful? Yes No