yes i have tried writing the select query i both the table and form’s init method…but whn i debug ther recid value is ZERO
oki…
Then let me put it simple way… forget the previous ones.
In your Details form–
lets A-is ua table name
go to tables-- Atable-Override Initvalue method
include these codes
this.emplid = curuserid();
this.vendacct = empltable::find(thsi.emplid).vendacct…
it will work for sure!!
no shon…its not getting the values…
in the above code-- whether its taking current empl id??
no its not fetching the emplid
sorry- put it this way… This.emplid = empltable::useridemplid(curuserid())
yes shon it works, but i want the vendor acc no of the employee id (i.e) the employee record which i have currently selected…
ok… details is your customized form… right??
in that case, why dont you extend(EDT) the field in emplid and vend acct in details form to same as that of the fields in employee table???
Creating relation solves the problem .
In Details table ,create relation for EmplId and VendAccount with EmplTable…the respective EmplId and VendAccount details are displayed automatically