Relation

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 :frowning:

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 :frowning:

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 :frowning:

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 :slight_smile:

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?