How to filter lookup fields (1 Viewer)

[aubrey1983]

I have two tables.

1st table, has the following fields:
1) EMP_ID (Autonumber, key generated by Access, which it cannot be removed or change)
2) EMP_USERN - employee username

2nd table, has the following fields:
1) DATA_ID (Autonumber)
2) EMP_USERN - Lookup field to table #1
3) EMP_HOURS - Decimal

Issue:
I wanted to filter the view in 2nd table where EMP_USERN = UserEmailAddress. Access is throwing an error:
"Access web app can't convert the value of to the specified data type."

How do i solve this? because in a transaction table, before you show it in a view you want to filter it, to improve performance.

 

[aubrey1983]

For now i got the work around by using query

This is by combining the two table together so the where clause will work properly, by using the field in "Short Text" data type, rather than the field in lookup data type.

I hope there's a better solution.

-Thanks-