I have a master/detail form that I need to put a where clause on the detail portion of the form.
I have tried: EDIT USING purordernew arrange shoploc by part ORDER BY vendor# where shoploc.invweek = 'p' It does not work. If I remove the where clause the form opens but not with filtered data. I am thinking I will have to do a view for the detail table(shoploc) but was hoping there was a better way. Does anyone know a better way to do a where clause on a detail table of a form? TIA Dan Goldberg
