Sorry if this is an old question, I just start using SC8.
I have tables of 3 level:
Invoice detail
- inv_items_id
Items - item_id
- item_type_id
Type - type_id
- Description
The SQL:
SELECT inv_items_id, items_type_id, Description FROM Invoice_Detail
INNER JOIN Items ON inv_items_id = item_id
INNER JOIN Item_type ON item_type_id = type_id
ORDER BY Description
The resulting grid is O.K, but I cannot create a search field on Description.
How to select the Description as filter and “ORDER BY” ? I use “item_type_id” and lookup Description but nothing return.
Regards,
Almond Wong