Combining Data From Different Tables (2003 (11.6566.6568))

[bbrown5]

We will be involved in a exercise where a form capturing the same type of data will be loaded onto several stand alone tablet PCs. At the end of the exercise I will need to combine all data collected from the stand alone tablet PCs into one database so that statistics can be extracted.

How can I append data from one table to another without loosing any data.

Thanks!

[HansV]

One way would be to add a field identifying the tablet PC (a number, or a name, or whatever is handy) to the table.

See <post:=559,644>post 559,644</post:> for some other methods to guarantee uniqueness of records entered on different computers.