How to show table with search filter from other ta

Hi,

In the old Grid it was possible to create a "advanced search criterie" with selections/filters from other tables...

example: I create a table view from virtuemart(VM) . orders and show:
order number
order price

then i would like so show all orders with a spesific product.
where database.virtuemart.products = 1234


How can this be done in the latest table JX?

And yes i am trying understand - how-to-create-a-database-view-and-use-it-with-tools-jx



Eddie

So my table names is....
k1sg2_virtuemart_products and k1sg2_virtuemart_orders

there is 1 common coloms in the tables... - virtuemart_vendor_id

I would like to create a view witch shows both tables and all tables...
so I can select and filter in table JX view...

I tryed some queries but it failed.. so any help will be nice

tnx, Eddie