Hi there,

I don't quite know where to write this post, so I hope here will be ok

I was wondering if it was possible to have the equivalent of [FMP-CurrentRecID] using odbc.

I'll explain myself : using [FMP-CurrentRecID], I'm able to easily edit, delete or display details of a particular record.

The problem is, I also want to retrieve all data from my FMP, using odbc, and still access the data throught the file ID.

Is that possible ? Is there a way to ask for the record ID using odbc ?

Thx for your answers,

Jerry

just a precision note,

I need to know if I can retrieve the record ID through odbc, not if I can query using the rec id (though they probably are related problems)

thx

forget that, I found the answer, it was quite stupid actually, just used a calc field with the state of the actual record.

I suck, deeply :S

Jerry