Article View: comp.sys.mac.databases
Article #655FMP - Numbering Subsets of Records?
From: James E. Mitchell
Date: Sun, 24 Jan 1993 22:57
Date: Sun, 24 Jan 1993 22:57
28 lines
1762 bytes
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.MitchellShow 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