synchronize

[ice-9]

Hi all,

I want to make a synchronize function in access.
I have two methodes, and i dont know what is best, since i have no experinece with synchronize functions.

Its about meeting information.

An employee has a meeting. He creates his meeting in the database. This way his meeting id is reserved. The employee goes to a client. Takes his laptop with the program. Fills in the information. Goes back to his company. push the botton, and the files from his latop synchronize with the main database under the reserved meeting id.

for example:
meetingID 7 is reservated.

meetingID----ActionID
6----1
6----2
6----3
8----1
8----2
8----3

The employee comes back:
6----1
6----2
6----3
7----1
7----2
7----3
8----1
8----2
8----3

MeetinID and Action ID are PK.

Now the question. I can also create a unique field for the action table. So that actionID and MeetingID wil be no long PK, just one field that identifies. But for the synchronize function, is it harder to program? Or does it make no difference? can you simpy add them ? or is it better to keep using the 2 pks.

please help

thanks

Joost

 

[ice-9]

Is it clear what i want to know ?