In OI 2.61 I had a subroutine that would read

field 6 from SYSREPOS the APP*OIWINEXEFORMNAME. The 2nd value in field 6 would be the DBTABLE name that the form was using. I used this to open the form's data table in my subroutine. THIS IS NOT THE CASE IN 3.4. HELP…. What record (FORMNAME) and field can I record to obtain the database table that is associated with the form. Thanks… Steve Carlson [email protected] </QUOTE> —- === At 03 NOV 1997 12:21PM John Duquette wrote: === <QUOTE>Steve, When the form is running you can get the TABLE property which will show you what table the control is bound to. If you want to check a table programatically you could do something like the following: Function GetTable(FormName) Record=' Key =@appid : '' : FormName

Open 'SYSREPOSWINS' to h Else

Return 'ERROR'

End

Read Record from H , Key Else

Return 'No such form'

End

Val=Record

Return Val

The 3rd entry in my form was a database bound entry

so any bound control should have an entry in position

23.

Let me know if you have any problems.

John Revelation

John,

Thanks… Field 3,23 from the SYSREPOSWINS record

worked perfect. This was for a generic Audit Trail subroutine

which writes the old and new records when a record

is changed, and also records whenever any user opens

any Form. It quit working a while back and I couldn't

figure out what happened 'til now. You saved me a lot

of looking. Thanks… Steve Carlson

View this thread on the forum...