Wondering if there is a better way to do this?

[Pyro]

Hey,

I have 4 tables:
tblproduct_record{productid, productname}
tblstocktake_detail{stocktakeid, sdate, notes}
tblstocktake_product_in{piid, stocktakeid, productid, numberin}
tblstocktake_back_order{boid, stocktakeid, productid, numberbo}

I'm trying to make a query that shows productname, sdate, notes, numberin, numberbo

Rather than stuff around trying to make several queries and joining them all up, is it possible to create just one query that will show all of this info?

 

[MStef]

As I can see, there is no foreign key in tblstocktake_detail. Put it, make a RELATIONSHIPS via "productid", and make a query (one query).