DroidDB Tip of the Month
DroidDB® Tip for January 2015
One Form Modifying Two Tables
In general, a form can read data from multiple tables, but it can only write one table. If you want a single form to update two tables, here's how to do it.
Say you have a FORM_A which is built over TABLE_A and you want FORM_A to update TABLE_B. Do the following:
(1) Create a form (FORM_B) over TABLE_B
(2) On FORM_B create a macro (MY_MACRO) that:
(2-a) Positions to the record you
want to change (or create a new record)
(2-b) Sets the value
(2-c) Launches FORM_A
(3) Set the "startup" macro on FORM_B to be MY_MACRO
(4) On FORM_A, provide a button (or macro step) that launches FORM_B
Top rated! I needed a solid database application development tool for mobile devices. I chose DroidDB for Android OS because it provided a way to get a strong product to market quickly. DroidDB is relational, gives me control over form layout, handles macros, and supports events. It works on all Android versions I have tried and is a great companion product to SYWARE’s VisualCE.
Mark Read, President
SyntegraTech, Inc.
