>>>For parent child views the child view would have a filter of;
> Parent.ID = ?lcParentID<<
>
>Sorry to be so dense about this. When I add a filter to the child view only the child view fields are shown in the dropdown list box. You are indicating I need to choose the Parent.ID field. How is this accomplished since the parent fields are not in the drop down box?

Rixon,

Teh child tabel has a foreign key that relates it to the parent table. Use that field in the filter. For example;

Customer tabel ahs CustID as the primary key adn Invoice has CustId as a field that relates to the customer table. You would use the Invoice.CustId field in the filter.