FileMaker Pro 3.0 questions 
Author Message
 FileMaker Pro 3.0 questions

I have some questions regarding FileMaker Pro v3.0.
I am using the Macintosh version, but I expect these issues to be the same
for the PC version (except maybe the 3rd topic.)

Please help! This first issue is especially important:

* If I have a portal showing a list of fields, how can I sort this list?
I know I can sort the database using these fields, but I just want to sort
this list on the main record. Sorting the related database file that the
entries are coming from does not do it.
  Ideally, it would keep this list sorted automatically after each new entry,
or modification.

* Is it better to relate files on a numerical field, such as a unique serial
number, or is it just as fast to use a text field, such as a name.

* How can I close a database, and all of its related files? When I close a
database (command W), and then switch to a database window to close that one,
bringing it to the foreground makes it launch all of its related databases.
Therefore, if there is a circular link, I can never quit all of them. The only
way I have figure out how to do this is to quit FileMaker Pro and launch it
again. A good example of this kind of situation is the "Integrated Solution"
example. Try opening that database and quitting it. Look in the window menu
to make sure that they're all closed. (They might be hidden).

Thanks for any help. I would really appreciate if your replies are E-mailed to
me, in case I miss your message here.

Thanks,



Mon, 22 Jun 1998 03:00:00 GMT
 FileMaker Pro 3.0 questions


Quote:

> * If I have a portal showing a list of fields, how can I sort this list?

Bradley -

This question has been asked also in the mac.database newsgroup where I
got the answer.  You can't directly sort the portal but must first export
the data, sort it with a script, and then re-import to establish a "new"
creation order.  Evidently FMP uses the creation order as a default
setting for portal views.

Quote:

> * Is it better to relate files on a numerical field, such as a unique serial
> number, or is it just as fast to use a text field, such as a name.

I usually use text unless I need to verify ranges...

Quote:

> * How can I close a database, and all of its related files? When I close a

I usually just quit but another way is to use the close item on the file
menu until they're all gone.

Now I have a question if you don't mind...

How do you convert the result of a calculated field (number format) to
text?  I have calculated ages using date of birth & current date, and now
want to sort & summarize them into predefined ages (count those who are
<15, 16, 17... 49, 50, >50).

Any ideas?

Thanks & good luck,

Tom



Mon, 22 Jun 1998 03:00:00 GMT
 FileMaker Pro 3.0 questions

Quote:

> How do you convert the result of a calculated field (number format) to
> text?  I have calculated ages using date of birth & current date, and now
> want to sort & summarize them into predefined ages (count those who are
> <15, 16, 17... 49, 50, >50).

Hi Tom,

I may be missing something here, but it seems you would simply created
another calculation field that = your number field, but define it to have a
"text" result.

Kind regards
--
Don R McCamey
MasterWare, Sydney Australia



Thu, 25 Jun 1998 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Filemaker Pro 3.0 questions

2. FileMaker Pro 3.0 Question

3. Claris Filemaker II -> Claris Filemaker Pro 3.0

4. Filemaker Pro Server V3 and Filemaker Pro V5.5

5. Filemaker Pro Unlimited or Filemaker Pro Server?

6. PC Filemaker Pro v3 file to Mac Filemaker Pro 2.1

7. PC Filemaker Pro v3 file to Mac Filemaker Pro 2.1

8. ***** WTB: Filemaker Pro 3.0 for Win-95 *******

9. verkaufe guenstig: FileMaker Pro 3.0 Mac Ed., englisch

10. filemaker pro 3.0 conflict

11. Filemaker Pro Server 3.0 For Windows NT

12. FS: FileMaker Pro 3.0 and 4.1, Mac OS's


 
Powered by phpBB® Forum Software