Hi
I'd like to be able to provide similar functionality and look and feel demonstrated in the tutorial Building the Sample Mobile Application.
While the tutorial demonstrates the use of one table, Customers, in a List that when being navigated updates related Textbox controls on a mobile device, in my application I want to be able to display information in one table based on a user's criterion related to three other tables.
In other words, a user can only view records in the Action table if that user scheduled in that Action, attended an event in that Action or was billed in that Action, with scheduling, attending and being billed all being in three separate tables. Due to normalization, the Attend records are related to the Action table via the Scheduling table, while the Scheduling and Billing have direct relation to the Action table as shown below.
I have created a view that works in MariaDB to display the records I want, and I can get those records to display in the List.
Since (to my knowledge) a SQL view derived from multiple tables can't be updateable, and therefore doesn't have a primary key, I indicated the List's List Properties|Return Value Type to be Field and then in the Return Field value the primary key of the Action table as reflected in the view (cas_guid).
Not sure if this is way too much information or not enough, but basically, can I have a List populated by a View and then display Textbox controls (or any data-bound control) that are updated with their related data as I navigate up and down the List?
And if so, how? <VBG>
I'd like to be able to provide similar functionality and look and feel demonstrated in the tutorial Building the Sample Mobile Application.
While the tutorial demonstrates the use of one table, Customers, in a List that when being navigated updates related Textbox controls on a mobile device, in my application I want to be able to display information in one table based on a user's criterion related to three other tables.
In other words, a user can only view records in the Action table if that user scheduled in that Action, attended an event in that Action or was billed in that Action, with scheduling, attending and being billed all being in three separate tables. Due to normalization, the Attend records are related to the Action table via the Scheduling table, while the Scheduling and Billing have direct relation to the Action table as shown below.
- Action (cas_guid)
- Scheduling (rfs_fk_action)
- Attend (att_fk_rfs)
- Billed (bil_fk_action)
- Scheduling (rfs_fk_action)
I have created a view that works in MariaDB to display the records I want, and I can get those records to display in the List.
Since (to my knowledge) a SQL view derived from multiple tables can't be updateable, and therefore doesn't have a primary key, I indicated the List's List Properties|Return Value Type to be Field and then in the Return Field value the primary key of the Action table as reflected in the view (cas_guid).
Not sure if this is way too much information or not enough, but basically, can I have a List populated by a View and then display Textbox controls (or any data-bound control) that are updated with their related data as I navigate up and down the List?
And if so, how? <VBG>