:)hi to all..

I have a query compose of 4 tables this tables are connected to each other. Like products is connected to inventory,then also connected to order details, and connected to order. But when i make a query with this tables i cant able to see the value of the field.

please do help...thanks....

Give detail what tables you are including in the query and what is the value which is not shown in the query

Give detail what tables you are including in the query and what is the value which is not shown in the query

Sorry for that..

I when i combine the order details.products and order the query will work fine, but if i include inventroy transaction table the query will not show any value.

thanks for the reply:)

what is in the inventorytransactions table
if this is empty or does not have any matching record query will not show any data

what is in the inventorytransactions table
if this is empty or does not have any matching record query will not show any data

The inventroytransactions table has a value. When the other 3 tables that i mention before put into query it works fine, it will display data but then when i try to put the tinventory transaction table it wont work.

Can you upload some sample data

Can you upload some sample data


Ok this is the sample..


Thank you...

You have not included the query which is not showing the data
also tell me on what field you are joing the table inventory transactions