On 2010 Mar 9, at 9:48, Will Cooksey Jr. wrote:
Make two databases, one database is just an interface, the other is
just the data. Distribute the interface database, put the data
database on a server, you can update it as needed.
That doesn't quite do it, Will.
Perhaps an example will help. Let's say I distribute the 2010 version
of the data file, with 700 words and phrases in it.
During the following year, Tutor A adds 80 prepositions to his copy
of the file.
During that same year, Tutor B adds 120 rhyming pairs to her copy of
the file.
In 2011, I want to distribute another data file that includes an
additional 300 words and phrases, above and beyond the original 700.
I want both Tutor A and Tutor B to be able to make use of the 300 new
flash cards (as well as any revisions to the old ones) IN ADDITION TO
the records they've already added to their own systems. But I have no
way of knowing in advance how many new cards the tutors may have
added, so I'm not sure where to start numbering the 300 new ones, or
if I should even make the attempt. (Still, I really need each flash-
card record to have a unique ID number.)
