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


Back to List »

Visit our store

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.

signup for our newsletter