Your Name wrote:
"jife" <no at (no spam) email.please> wrote in message
news:4ac253af$0$26310$9b536df3 at (no spam) news.fv.fi...
There is a database where entries are added from a big paper file. It's
core is persons in one table with id's auto-generated and their
actions in another related table likewise auto-generated id's. Now it
seems there was two or more persons availale for data entry. But is it
possible to split this work for simultaneous data entry and combine the
resulting databases later? Any examples?
In an ideal world, the paper file is well organised so that all the
information for each person is together, then one data entry person could
start at the beginning while another data entry person starts from the end,
and there will be no overlap or double entry problems.
Unfortunately, since this is the real world, and the paper file is likely to
be one large mess of double-ups and have information scattered troughout it,
which means no matter what you do in the data entry, you going to have to go
back and do some tidy up.
For the actual data entry, you can either:
- run the database on a server or hosted on one computer,
and accessed by the other computer at the sam time,
(This way can help with double-up data entry if the users
perform a Find to see if the person already exists before
plowing on to enter the data.)
or
- run two copies of the database, one on each data entry
person's computer, and then import the data from set
into the other (after making backups of both!!).
Helpfull Harry
)
Thanks for realistic views,
actually we have FP Pro's and separate workstations available. And
probably the persons would be working partly different times w/o
network connection.Your second suggestion: Is the combination of
separate parts of work possible. The auto-generated id:s bother me -
what kind of code would be necessary to unify the final database?
