jadachDevClub member 12/28/2017 | |
On add page before display you will need to get the values from the parent tables - maybe put them into a session variable, then use those in your before added event. |
admin 12/30/2017 | |
In event like BeforeAdd you have access to all values entered on that Add page. If you need to access fields from other tables you either need to use API calls or SQL Queries. |
I
|
i.NoLim author 1/2/2018 |
I apologize for not replying sooner, because of the holidays I was not at work. On add page before display you will need to get the values from the parent tables - maybe put them into a session variable, then use those in your before added event.
In event like BeforeAdd you have access to all values entered on that Add page. If you need to access fields from other tables you either need to use API calls or SQL Queries. To access master table info: https://xlinesoft.com/asprunnernet/docs/getmasterrecord.htm To access any field in any table: https://xlinesoft.com/asprunnernet/docs/db_query.htm
//SET THE "CHECK_SUBSIDY" IN CHARGE TABLE EQUAL TO "TOTAL" IN FAMILY TABLE; SET "FAMILY_ID" IN CHARGE TABLE EQUAL "FAMILY_ID" IN APPLICANT TABLE BY CHECKING SAME "APPLICANT_ID"
|
jadachDevClub member 1/7/2018 | |
Try something like this. I am sure there are other ways, but I do think this will work. CREATE VIEW [dbo].[Subsidy_View]
XVar data = pageObject.getMasterRecord(); |
I
|
i.NoLim author 1/8/2018 |
Try something like this. I am sure there are other ways, but I do think this will work. Create 2 new views in your database (I assume SQL Server) CREATE VIEW [dbo].[Subsidy_View]
XVar data = pageObject.getMasterRecord();
|