Hi,
I created a Data Related Table for my Job Table and in this new Table Icreated a LookUp Field to another Table, lets call it Job Functions.
This works but now I need to filter my results. The Job Function Table has the Job No. stored but I dont have it in my Data Related Table. I cant access the PK Field which links my table to the anchor table.
Is there any way to get around this problem?
Best Regards
Caner
hougaard Answered question 3 days ago
Sorry, filters on lookup (and other) fields can only be done from fields in the current table.
This is why that you see fields replicated in places where it doesn’t really is needed, from a user perspective, like some of the fields added to the Sales Line (that only belongs on the Sales Header).
hougaard Answered question 3 days ago