🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #655

FMP - Numbering Subsets of Records?

#655
From: James E. Mitchell
Date: Sun, 24 Jan 1993 22:57
28 lines
1762 bytes
Imd like to number subsets of records in a reasonable way. To be
specific, I have a database of people with multiple records per person.
Imd like to create a sequence number for each record within the group,
starting with the number one. i.e. Imd like the record set to look like
this

Jones	1	.....
Jones	2
Jones	3
Adams	1
Adams	2
Smith	1
Smith	2
Smith	3
Smith	4

The numbers are to be in their own field and should be revisable as new
records are entered.

It seems as though I ought to be able to do this with 
same file, but Imve run into trouble because relooking-up always goes to
the first instance of the record. Any suggestions are welcome - even a
good reference on how to use relookups effectively. More specifically, is
there a way to copy the value of a field in the previous record to one in
the current record? I believe that would solve my problem.

BTW I saw an old Claris note suggesting the use of exporting to a clone
and then doing a fancy lookup. Thats too much for me.
Technical Details
Message-ID: <1993Jan24.225721.14571@netnews.noc.drexel.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!usc!howland.reston.ans.net!bogus.sura.net!darwin.sura.net!newsserver.jvnc.net!netnews.upenn.edu!netnews.noc.drexel.edu!n1-12-230-telecommunications-and-networking-group-development.ocs.drexel.edu!James.Mitchell

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!usc!howland.reston.ans.net!bogus.sura.net!darwin.sura.net!newsserver.jvnc.net!netnews.upenn.edu!netnews.noc.drexel.edu!n1-12-230-telecommunications-and-networking-group-development.ocs.drexel.edu!James.Mitchell
From: James.Mitchell@CoE.drexel.edu (James E. Mitchell)
Newsgroups: comp.sys.mac.databases
Subject: FMP - Numbering Subsets of Records?
Message-ID: <1993Jan24.225721.14571@netnews.noc.drexel.edu>
Date: 24 Jan 93 22:57:21 GMT
Sender: news@netnews.noc.drexel.edu
Organization: Drexel University
Lines: 28
X-Xxmessage-Id: <A78896E44A020CE6@n1-12-230-telecommunications-and-networking-group-development.ocs.drexel.edu>
X-Xxdate: Sun, 24 Jan 93 23:56:36 GMT
X-Useragent: Nuntius v1.1.1d13