Cross-Reference Search tool

[PLloyd]

Hello,

I'm not sure if this is even possible, but hoping it is and someone can point me in the direction to get started creating!

I'm wanting to build a search tool that will allow me to cross-reference products with multiple names.

For example:

Type in a customer name and the tool spits out all the products sold to that customer and the variation of names those products might go by, or type in a product name and it provide all the other names that products goes by and the customers it is sold to.

[v-yuta-msft]

@PLloyd ,

Could you please share some sample data and your expected result?

Regards,

Jimmy Tao