Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #599

serializing a subset of records (FMP6)

Show all headers | View raw

I frequently run across a situation in which I need to sequentially
number a subset of records. I have done this several different ways
over the year, but I wanted to see if there is a "right" way.

For example, let's say I have a "jobs" table and a "proofs" table. A
job can have many proofs. Proofs are numbers 1, 2, 3, etc. Simply
serializing the number won't work, because that doesn't "reset" for
each job. In the past, I have scripted it ("Am I the first record in
this relationship? If not, what was the last one? OK, now add 1 to
that."). I also tried to do a calculation to the same effect (I might
have had to concatenate a few values and then pull the right-most
number, or something like that). Both of those seem kind of dirty. Is
there a more elegant way?

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar

Thread

serializing a subset of records (FMP6) "Joseph O'Brien" <obrien1984@hotmail.com> - 2012-02-01 12:18 -0800
  Re: serializing a subset of records (FMP6) Martin Τrautmann <t-usenet@gmx.net> - 2012-02-01 21:52 +0000
  Re: serializing a subset of records (FMP6) HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-02-02 13:26 +1300

csiph-web