This project is very depressed, the database should be branches and the main store to transfer, and there is no fixed IP on both sides. Use DDNS, I don't know how stability is, I am a solution.
Data table master customs use int
The ID type default value in SQL Server is (NewID ()) is OK. Record time, of course (GetDate ())
Createguid or CreateClassID Sample: VAR AGUID: Tguid; Begin Olecheck (CreateGuid); ShowMessage (CreateClassID); END;
To add US COMOBJ in USE;
