Hello,

I want to create a view which includes fields from different tables. How can do it?

Thanks in advance,

Mavis

Hello Mavis,

Use the "Composite Tables" table, it will likely have the two tables combined that you need. What tables are you trying to include in the View?

Hi Andrew,

I want to create a complete back order report which is same as in the Accpac in dos. The Order Action report in O/E doesn't show the quantity on hand. I don't know if any table in O/E has that field...

By the way, I could not find the "Composite Tables" table. Can you please tell me more detail?

Thanks,

Mavis

Why not add the "Qty. avail" column to the order action report? The fields on this report are user selectable.

Oh yes, the table name is "Adagio {Composite Tables 8.0C}" in the list of tables.

Hi Andrew,

Our middle part of Item # is the suppliers' code. We want the Order Action report can be sorted by the suppliers' code and have each supplier subtotaled. However, the order action report can't do it for us. Do you have any good idea about it?

Thanks,

Mavis

What columns do you want to show on your View?