Does software send complete database every time?

No, This software only sends only changed records like new/updated/deleted records and not complete database each time.

Is my database secured?

Yes, Data transfer between iPhone side DBViewer Plus and Server application is secured as 128 bit AES is used for encryption.

How to get UDID of iphone?

To get Device ID, connect your device to your Mac/PC and launch iTunes. In iTunes, select your device in the ‘Devices’ section and navigate to the Summary tab. Click on the Serial Number label to reveal the Identifier field and the 40 character UDID. Press Ctrl+C to copy the UDID to your clipboard, and paste it in Device ID and Confirm Device ID field.

How can user set lookup to original table from anther table column?  is it possible?

Yes, it is possible. User can set look up from iPhone side DBViewer Plus software. It can be implement it from Design View. On Multiple Records View, select "More Options->Design View”, then select specific column name for which you want multiple values (Lookup).  You will get “Field Properties” window which will have “Lookup” tab. Select that “Lookup” tab. Now you will get Profiles (Tables) available on your iPhone. Select Table from left side PickerView and from right side Pickerview select column name which you want to use as a lookup.

Now Lookup has been set to your column. When ever you will open your table (on which you have implemented lookup) and try to Add/Edit record, that particular column will have lookup (Drop down control) and you can select particular value from this lookup.

Whenever I add/edit/delete record on iphone, in Record view I get Red/Cyan color.

Cyan color indicates that record synchronization is still in progress.Red color indicates that Record has problem while syncing with desktop database. icon on this screen shows information related with record syncing process.