I have an application for recording information spread over a Desktop PC and a Tablet PC. The main application is housed on the Desktop PC.
Basically I want to export customer detail to the mobile device, conduct a site survey by recording various data, return to office and import the new details back to the Desktop.
I have two tables on the desk top called:
1. Customers
2. Site Details
I have two tables on the Mobile Device called:
1. Customers with Site Details
2. Imported Details (customers & Site Details) used for Archiving.
I am trying to achieve three tasks.
A.
Export to the mobile device the customer name, address & contact details in to the appropriate fields in the mobile Customers & Site Details table.
B.
Import from the Mobile Device the site details to the desktop Imported Details table. The customer details exported from the desktop is ignored in the import as the details are already in the customer table on the desktop.
C.
Archive the mobile data after the import task.
From my knowledge to date I think I need to do the following.
A.
Exporting new customer details to the Mobile should add a record to the customer table on my mobile device. There should be no records in this table from the previous site visit due to the Archiving executed in point C.
B.
Importing to the main application in the Desktop PC should be added as a New Record to the Imported Details table only, customer details are already recorded.
C.
Auto Archiving would need a duplicate table to accommodate the data fields in the main mobile table.
Questions:
Can a record that is imported in to the desktop be ADDED as a new record without affecting the existing records already in that table?
When executing the Archive task after the import can the original data be deleted from the main table in the mobile device after archiving? If yes what would be the best way to remove the record?
Can I achieve the above on two licensed Runtime versions of Alpha 5?
In the event of the Synch feature can not talking to each other I will execute the importing/exporting feature through a third partly desktop folder.
Sorry if this sounds a bit basic but I can give more details if required.
Regards
Andy
.
Basically I want to export customer detail to the mobile device, conduct a site survey by recording various data, return to office and import the new details back to the Desktop.
I have two tables on the desk top called:
1. Customers
2. Site Details
I have two tables on the Mobile Device called:
1. Customers with Site Details
2. Imported Details (customers & Site Details) used for Archiving.
I am trying to achieve three tasks.
A.
Export to the mobile device the customer name, address & contact details in to the appropriate fields in the mobile Customers & Site Details table.
B.
Import from the Mobile Device the site details to the desktop Imported Details table. The customer details exported from the desktop is ignored in the import as the details are already in the customer table on the desktop.
C.
Archive the mobile data after the import task.
From my knowledge to date I think I need to do the following.
A.
Exporting new customer details to the Mobile should add a record to the customer table on my mobile device. There should be no records in this table from the previous site visit due to the Archiving executed in point C.
B.
Importing to the main application in the Desktop PC should be added as a New Record to the Imported Details table only, customer details are already recorded.
C.
Auto Archiving would need a duplicate table to accommodate the data fields in the main mobile table.
Questions:
Can a record that is imported in to the desktop be ADDED as a new record without affecting the existing records already in that table?
When executing the Archive task after the import can the original data be deleted from the main table in the mobile device after archiving? If yes what would be the best way to remove the record?
Can I achieve the above on two licensed Runtime versions of Alpha 5?
In the event of the Synch feature can not talking to each other I will execute the importing/exporting feature through a third partly desktop folder.
Sorry if this sounds a bit basic but I can give more details if required.
Regards
Andy
.
Comment