I have made a DBGRID that is connecting my open orders to my available inventory. The grid is working but I want to enhance it a little. With the main table I can limit the information based on whether the order has shipped and the product line.
What I want to do is limit the connecting table information (PRODPART) to just the parts that will be shipped (not all the parts that make up the product). There is a column in this table that has either a 'y' or a 'n' for shipping. Since the driving table does not have this column in it, how would I limit the rows? I have read the PDF files and looked at the sample databases but find nothing about DBgrids to meet this condition. If there is a file with detailed information about grids, I will be happy to investigate that. Jim
