My client has a business process where a pickup/delivery driver uses a tablet with APEX loaded to record the serial numbers of equipment s/he has just picked up. When the driver returns to the depot, the client wants to copy all the data from a specific table on the tablet into a "pending" table on the database server (both have the exact same column structure) then process the records into the master database.
My thought process is to create a blank form that is used to invoke a Procedure/Function that selects the tablet's records into a cursor, then appends them to the pending table in the master database, then deletes the rows in the tablet's database...
I am at a semi-loss as to how to do this. How do I define a table in the master database that, in reality, resides in the database on the tablet?
Is this a db-link? I know this is DBA-101 stuff, but I am no DBA - just a frustrated Systems Analyst who fell in love with APEX and can write PL/SQL.
Thanks for any help and/or advice.