G
Guest
I am converting an Access 2003 database to an Access Data Project using a
SQL Server back end.
I have a form that is bound to an Employee table and inserts, updates and
deletes records. My table does not have Employee name, it is another table.
This field would be read only and is not in the table I'm bound too.
EmployeeName comes from a seperate table, in Access they are using a
dlookup() formula.
I would like the dlookup to read a stored procedure and return an Employee's
Name.
Here's the code
=DLookUp("EmployeeName","sp_NameLookup","@EMPLOYEE =
Forms![frmLastStepDates]!txtEMPLOYEE")
I was unsuccessful.
I also tried joining the two tables, then using a select statement as the
record source. I set the UniqueTable property to the table I want to update
and put the same SQL statement I used for the record source in the
ResyncCommand. I disaled the employeeName field too. This failed as well,
It would allow updates.
Mike
Thanks,
Mike
SQL Server back end.
I have a form that is bound to an Employee table and inserts, updates and
deletes records. My table does not have Employee name, it is another table.
This field would be read only and is not in the table I'm bound too.
EmployeeName comes from a seperate table, in Access they are using a
dlookup() formula.
I would like the dlookup to read a stored procedure and return an Employee's
Name.
Here's the code
=DLookUp("EmployeeName","sp_NameLookup","@EMPLOYEE =
Forms![frmLastStepDates]!txtEMPLOYEE")
I was unsuccessful.
I also tried joining the two tables, then using a select statement as the
record source. I set the UniqueTable property to the table I want to update
and put the same SQL statement I used for the record source in the
ResyncCommand. I disaled the employeeName field too. This failed as well,
It would allow updates.
Mike
Thanks,
Mike