Lookup filter issue

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
shanejoan
User
Posts: 2

Lookup filter issue

Post by shanejoan »

Hello,
I am looking to filter a lookup table drop-down.
I have a customer, customer contacts and customer visits table.
For the customer visits table, I wish to filter the Customer Contacts info specific to that particular company. However, all Customer Contacts appears for all customers. I suppose I could create a view lookup for this, but am unsure if I am approaching the problem incorrectly. I tried to add the filter below for that particular drop-down field, which generated properly but ended up blank when it should not have (a customer contact existed for that particular customer. I'd be curious how to do this appropriately. Thank you!

FILTER field for the drop down (customer contacts) "[IDCustomer] = & <IDCustomer>.CurrentValue"


Webmaster
User
Posts: 9425

Post by Webmaster »

You should enter a phrase that evaluates to a proper SQL WHERE clause. For example, assuming <IDCustomer>.CurrentValue always return the ID of the current customer:

"[IDCustomer] = " & <IDCustomer>.CurrentValue


Post Reply