Help with filter in form

[vincentSala]

Hi All,
Can anyone point me to the right resources (literature, videos, posts...) to solve the filter in the picture below??
Trying to get the associated records once the skuId is selected in the form...

Thanks very much

Best regards

Vincent

[dpoggemann]

Hi @vincentSala ,

I just created a Sku, Variety, and Sku Variety tables with the relationships as you identified and created a Canvas App Page with the filter and the following code accomplished the filter correctly:

I am displaying the SKU name in the first combo box and filtering the second table based on the name of the SKU.

Hope this helps.  Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

[vincentSala]

Good morning Drew,

Trying to reproduce the filter with the information you have kindly provided.

I suppose when you use "Sku.Name", it is the table name plus the column name. In my case the name of the table has to be written in plural.

However, I am getting a delegation warning with no data in the combo.

Thanks very much

Best regards

Vincent

[rampprakash]

Hello @vincentSala

skus.skuId is a field in SkuVars ? if yes then you are comparing GUID with Value Field. thats why you are getting that error.

[dpoggemann]

Hi @vincentSala ,

I misunderstood your filter.  I thought you were trying to filter the SkuVar records but you are trying to filter the Varieties based on Sku selected in ComboBox1.  I will have to think more on this...

[vincentSala]

Hi Drew,

My apologies, I did not provide details enough.

Yes, trying to filter the 'varieties' table depending on one field in the 'sku' table.

Thanks a lot

[vincentSala]

Hi rampprakash,

Not a field in SkuVars.

Thanks a lot

Best regards

[rampprakash]

Hello @vincentSala 

Please use the if field front he respected entity to make it work.