also eric your instructions for displaying by userid clients only, i clicked on the main recordset wadaclients and clicked on filter but all i see is filter on the fields from that table. so do i select filter clientid = the session variable and userid ???
or do i choose filter the foreign key clientuserid = session variable userid ??
many thanks eric for all your help