Could you have different IDs - for example T1, T2 etc for ones the tutor adds, which could be auto-enter serial number, and then use 1-infinity without the prefix for your cards - assuming that your IDs could be made to over-ride the auto-enter. Can't think just now but I'm sure this can be done if the field's set up right?
This would have the additional advantage that the Tutor's cards could always be identified. On 9/3/10 16:18, "Richard S. Russell" <[email protected]> wrote: > 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.) > > -------------------------------- > Inbound email scanned by Mimecast. > -------------------------------- > <BR> @|from|cn|@ @|from|title|@ - @|from|company|@ Tel: @|from|telephonenumber|@ @|from|wwwhomepage|@ @|from|streetaddress|@, @|from|l|@, @|from|st|@, @|from|postalcode|@, @|from|co|@ ----------------------------------------------------------------------------------------------------------------------------------------- Media Square plc or any of its subsidiary companies may not be held responsible for the content of this email as it may reflect the personal view of the sender and not that of the company. Should you receive this email in error, please notify the sender immediately and do not disclose, copy or distribute it. While Media Square plc scans all outbound emails for viruses, it cannot be held responsible for any infected files that you may receive. Media Square plc advises all recipients to virus scan any file attachments. Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered Office: Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ This email message has been scanned and delivered safely by Mimecast. -----------------------------------------------------------------------------------------------------------------------------------------
