[support] RE: Counties field - a bunch of answers

[Oklahoma Wildlife Federation]

I will.  Thanks for the detailed instructions.  As soon as the 4.0 version
is up, I'll try it.
----- Original Message -----
From: Bob LeLievre <[EMAIL PROTECTED]>
To: TechRocks Support <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 1:29 PM
Subject: [support] RE: Counties field - a bunch of answers


> >>Q.  I downloaded, and it asks me for a password when I try to open with
> FMPro 5. If I offer "master" as the password, it starts to open, but
> then closes itself without displaying any info.  How do I open this file?
>
> A.  The ZIP_. file is designed to be part of the ebase system.  It's got
> fields, scripts, passwords, and relations already built in to work with
all
> the other ebase files.  When you open ebase, the ZIP_ should get opened,
> too.  Once ebase is open, you can poke around the ZIP_ file by clicking on
> WINDOW (in the top filemaker menu line) then click on ZIP_ in the file
list.
> To go back to ebase, click on WINDOW, then click on NAMES_
>
> ---------
>
> >> Q. I can't figure out how to do the replace Command.  Also, when I try
to
> work
> with the zip_ file I downloaded, it won't let me open it because it was
> created in FM 5.5 and I have version 4.1.
>
> A.  The file you downloaded does work only with Filemaker 5.  I'll post a
> Filemaker 4 version in the next day of so.
>
> To do the replace, do the following steps (these instructions work with
> Filemaker 5 and Ebase 1.03, but it should be pretty similar for Filemaker
4
> and Ebase 1.02):
>
> - Backup first.  You will be doing a mass overwrite of data, and you could
> screw up and overwrite the wrong field.
>
> - You need to be on a layout that has the COUNTY field.  I don't see it in
> any of the regular ebase layouts, so you'll have to modify a layout.  For
> example, you could modify the CUSTOM SCREEN 1. Click on the CUSTOM tab,
then
> click on VIEW (in the Filemaker menu line), then click on LAYOUT MODE.
>
> - You can add a field here.  Click and hold on the FIELD button (in the
gray
> left -hand column) and drag it over to the middle of the white layout
area.
> Let go of  the button.  This should pop up a SPECIFY FIELD box.  Scroll
down
> and field the COUNTY field.  It may not be in alphabetical order, so you
> might have to hunt a bit.  Double-click on the county field.  It should
show
> up on the layout.  You might want to make the field bigger to show long
> county names.
>
> - Click on VIEW, and click on BROWSE to get back to data entry mode.
>
> - Click on FIND ALL if you want all records updated.  You could find a
small
> subset of records first it you want to test it.
>
> - Click on the COUNTY field so the cursor stays in the box.
>
> - For Filemaker 5, click on RECORDS, then click on REPLACE.  A REPLACE
> dialog box should pop up.  Click on REPLACE WITH CALCULATED RESULT.  A
> SPECIFY CALCULATION box will pop up.  Click on the down-arrow next to
> "Current File("names_") in the upper left corner.  Scroll down and select
> LOOKUP FROM ZIP TABLE.  The list of available fields below it should
change.
> Double-click on COUNTY.  The text:
>
>      LOOKUP FROM ZIP TABLE:COUNTY
>
> should get filled in the white box in the middle.  Click OK, then click
> REPLACE.
>
> The REPLACE command is slow, so it may take a while if you have many
> thousands of records.  If a matching zip code is found, the COUNTY field
> will get filled with data.  You might want to scroll through some records
to
> make sure the county values look right.
>
> For Filemaker 4, the REPLACE command is found by clicking on MODE in the
> Filemaker menu line.
>
> Let me know how it works.
>
> ------------------------------------------------------------
> Bob LeLievre
> LeLievre Information Services
> List Management Services for Non-Profits
> voice:  617-474-9131
> email:  [EMAIL PROTECTED]
> website:  www.lelievre.net
>
>
> ------------------
> 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
> ---------------------------------------------------------------------
>
>



------------------ 
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:: archive@jab.org

To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
 ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------