🚀 go-pugleaf

boz@coos.dartmouth.edu (John Boswell) writes:


>My problem is, that I would like any books in a specific category to
>go sequentially, i.e., SCI.400, SCI.401, SCI.401, etc.  As I have it
>set up, if I enter a SCI book, then a Biography, then a SCI book, I'd get:
>SCI.400, SCI.402  (since the biography would get BIO.401).  I can't set
>up separate "autoserial" number fields for each category, since they
>would ALL increment by 1 as soon as I create a NEW record.  Is there a
>way for me to do what I'd like?

    Well, I really don't think there is a way for you to get what you
want. The kind of thing that you want to do is usally accomplished, with
relational databases like 4D and Double Helix, but using a file that
contains your constants, like record numbers, which are accessed and
updated over the live relational link between the files. This is a
capability that FM Pro doesn't have. You might be able to simulate it
with Apple Events, but it would be a real nightmare.

-Hades
--