3 and more level deep queries
Lets say I have 3 level relationship hirarchy (each come from a separate table/form):
How can I get a table (view) that would dispaly
Order number - Emploee ID - Company ID
All three IDs in the same row. As I see now only 2 level deep relationship is shown when building a new view. Thus I can get Emploee ID and Order number togehter, but not the company ID. And views are based on froms so I can't build a view that queries Company and Emploee first and then use that and query together with Order.
I think this is possible with some scripting. Is that the only way to achieve it?