Jim: What you're asking for is to be able to put a "where" clause on the slave tables. We have the ability to do a sort using the "arrange" command, but I've always thought a "where" clause would be so cool... But it isn't there.
I have never used an editable view in a form. But you could try creating a single-table, unsorted view based on your slave table with the appropriate wher e clause on it. That view SHOULD be editable... Karen > 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 > >
