Thread View: comp.sys.mac.databases
1 messages
1 total messages
Started by James E. Mitchell
Sun, 24 Jan 1993 22:57
FMP - Numbering Subsets of Records?
Author: 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.
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads