Hi ı have a reletion in my Supply table
I want open a contacts and ‘ST DANIŞMANLIK’ in my table
This is my Reletion
“Ship-to Address”.Code WHERE (Name=FIELD(Customer),Name=FILTER(ST DANIŞMANLIK))
But its not work how ı can do this?
Can u be more clear?
You want to apply 2 filters on Same name field?
Yes ı want make a two filter in one field ia it possible ?
Name=Customer and Name:=‘ST DANISMALIK’
Yes we can use…
I have created a new table and set table relation to Customer table as below
Customer.No. WHERE (Name=FIELD(Name),Name=FILTER(John Haddock Insurance Co.))
it is working fine…
make sure that your filters are not blank and correct
When ı do this relation its only work first filter Name=FIELD(Name), but Name=FILTER(‘ST’)) is not work
above code is an example done by me…
dont change your relation based on that…
on which table you want to set relation?
is that a base table or customized?
Now Name=FILTER(‘ST’)) is work but another field isnt work
“Ship-to Address”.Code WHERE (Name=FILTER(ST),Name=FIELD(Customer))
this my relation its must work but its not
My tables is Ship-to Address and Supply table.
I want a reletion wtih theese tables
Ship-to Address.Name:=Supply.Customer and Ship-to Address.Name:=‘ST’ ı want to this reletion but ı cant
what do u mean by it is not working?
are you sure you have ST value in Name field of “Ship-To Address” table?
Yes ı have ‘ST’ value in my Ship-to Address table
Somebody Help Me
what do u mean by it is not working?
Ship-to Address.Name:=Supply.Customer İS NOT WORK
Ship-to Address.Name:=‘ST’ İS WORK
Only Open (‘ST’) values in my relation field
Yes, you are right…second filter is over writing the first one…
other option you have is write code in onLookup trigger…
Yes ı agree you
but ı dont know how ı can write a code for this relation
Can you take me a example code ?
Please search the forum…am sure you will get lot of posts…
I search the forum and ı write this code:
LLookup=My Ship-to Adrress List
IF LLookup.RUNMODAL = ACTION::LookupOK THEN
“meeting \ support site”:=‘ST’
But its not work
Sorry…but can you explain what you are expecting from above code?