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. Will Cooksey Computer Support Specialist University of Arkansas University Information Technology Services [email protected] 479-575-2905
-----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Richard S. Russell Sent: Tuesday, March 09, 2010 9:03 AM To: [email protected] Subject: Updating Supplied Data I'm looking for some bright ideas to help guide my thinking about how to design a database system to permit periodic updates of data originating from the central source. I'm working on a project for the Literacy Network here in Madison, Wisconsin. The network has 2 kinds of learners: * ESL (English as a second language, non-native English speakers trying to learn English) * ABL (adult basic literacy, native English speakers who need help with reading and writing) Both kinds of learners can profit from the use of flash cards, but so far I've only worked on cards for the ABL half of the program. I'm still fiddling with the design of the FlashCards database, but my ultimate objective is to be able to hand each tutor a CD with a runtime program on it that will let her or him spit out flash cards, sort and categorize them, and track the progress of each learner at mastering them. Here comes the tricky bit. Let's say that the 1st such copy of the database I hand out has 700 cards in it, with sequence numbers from 1 to 700. A year later, I want to distribute an updated set that now has an additional 300 cards. If that were ALL I were concerned about, no problem. The new ones would just be numbered 701-1000. But, during that 1st year, I also want the tutors to be able to add their own cards to the original deck of 700, and if they do, they will already be using numbers in the 701-and-up range. As I say, I'm still fiddling with this, so I'm not committed to any 1 approach. Any advice on how to handle upgrades that will permit (a) tutor data entry during normal use and (b) periodic additions from the central office?
