fetch section record if any three fields match

Hi Team,

 

I'm looking for a solution where I can fetch the list of records from a section if the value of any three fields that i enter in the edit page form of a new record match with the current entry field values.

 

For example : In my current record I enter the values as follows for the customer CustomerA:

Field1 = 1;

Field2 = 2;

Field3 = 3;

Field4 = 4;

Field5 = 5;

 

Existing entries :

entry 1 : CustomerB

Field1 = 1;

Field2 = 2;

Field3 = 3;

Field4 = 6;

Field5 = 9;

 

entry 2 : CustomerC

Field1 = 3;

Field2 = 2;

Field3 = 3;

Field4 = 4;

Field5 = 9;

 

entry 3 : CustomerD

Field1 = 10;

Field2 = 12;

Field3 = 33;

Field4 = 62;

Field5 = 91;

 

then, in this case system should be able to fetch the entry with customer names-CustomerB and CustomerC  in a list and display in a dialogBox .

 

Kindly help.

Many thanks in advance.

 

best regards,

Sarika

 

 

Like 0

Like

1 comments

Hello,

 

Please, specify the problem in more detail, what are the user's steps when reproducing it, what is the actual result and what is expected.

Screenshots are highly appreciated and will help us to find the best solution for you.

Show all comments