One more thing to bear in mind. Ebase keeps sequential record numbers for you, but if you delete a record, those old numbers don't get re-used. So you can end up with big gaps in the numbers. That isn't a problem as far as Filemaker is concerned (or any other relational database for that matter), but it ain't clean.
As Walt has pointed out, the record ID in version 2 is VERY different and would likely drive you crazy if you want sequential numbers. Carl [EMAIL PROTECTED] wrote: > > In a message dated 03/05/2002 3:46:01 PM Central Standard Time, > [EMAIL PROTECTED] writes: > > > Ebase has it's own auto-entered record number and will store but not use > > your old record numbers. It uses those old numbers merely to match > > payments up with the correct person. > > Carl > > Carl, thanks for the rapid reply. I have been given four Excel spread sheets > with membership information on them - current members, lifetime members, > expired members and non-member donors. Each name has a unique number - > unfortunately not totally sequential as the former data base had been > corrupted and redone at least once, maybe twice. It would please me to be > starting all over again with totally sequentlial numbers. Do I understand > correctly that although I import the old ID numbers, ebase will assign new > ones? If so, where are the old ones stored - are they visible or must a > search be made for them - ie will ebase display two id numbers? > > We do not have a joining date but do have an expiration date. I see no > corresponding field in ebase - have I missed it? > > William Jones > > ------------------ > Reminder to each recipient: To change your list account preferences, go to > http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email >address you used to subscribe to the ebase support list:: [EMAIL PROTECTED] > > To unsubscribe send a blank email to [EMAIL PROTECTED] > --------------------------------------------------------------------- > ebase - Relationship Management for Nonprofits, http://www.ebase.org > --------------------------------------------------------------------- -- Carl Paulsen New Hampshire Rivers Council 54 Portsmouth Street Concord, NH 03301 603-228-6472 603-228-0423 Fax [EMAIL PROTECTED] ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
