• Registered: 2014-12-02
  • Posts: 136

Topic: Current record id from form

is there a way to get the current record id when using a form?

I would like to show all related items purchased together except for the current item being displayed.
I need to know the current record id being viewed to perform this query.

Thank you,
  Robb

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Current record id from form

If you call form using button with action "Show Record", you can get id of current record from Button with action "Save Record" on the same form:

Form2.ButtonSave.dbGeneralTableId ;
Dmitry.
  • Registered: 2014-12-02
  • Posts: 136

Re: Current record id from form

DriveSoft wrote:

If you call form using button with action "Show Record", you can get id of current record from Button with action "Save Record" on the same form:

Form2.ButtonSave.dbGeneralTableId ;

it seems to be off by one.

When using the dbItemID I am getting record id 8
When using the dbGeneralTableId I am getting record id 7.

8 is the proper id. 

Please advise .

Robb

  • Registered: 2014-12-02
  • Posts: 136

Re: Current record id from form

Any info on the offset of the two record ids?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Current record id from form

rjkantor wrote:

Any info on the offset of the two record ids?

Please attach your project with description, where you meet problem.

Dmitry.