Lee,
LM> I want to put a record number field in a detail table on a form
It's actually pretty easy, but it is different that what you might be
expecting. Add a column to your table frame and then define the field
that's created in the new column as a calculated field using:
self.recNo
recNo is a property of data-bound objects and returns the record number
of the underlying table. Also, remember that appended records (the records
added to the bottom of a table frame when you move beyond the last record)
have a record number of 0 until they're posted to the table. This stems from
the fact that the appended record doesn't truly "exist" in the table until
it's actually posted. (In SQL terms, this is called a "crack" record.)
(I may be mis-remembering the actual syntax. If self.recNo doesn't compile,
then try self.recNo().)
Hope this helps...
-- Lance
--- Maximus 2.02
---------------
* Origin: Mountain Retreat (1:216/506)
|