>Thank You Mark for your reply
>
>When I remove OR Portion of the SQL statement, I get no records at all.
>What I want to show up is one record regardless of the value for cStaff2.
>
>So if the user is filling out the form and I leave one of the fields (cStaff2) blank and save and go back into the form, I would want that record to show up, what is happening now is the record is not showing up
>
>Thank You
>
>Gary

So do you also want records that meet the join criteria AND any records where cStaff2 is blank? Or do you want records the meet the join criteria AND and records where ANY of the selected fields are blank? You are looking at having to do 1 of 3 things:

1. Use a UNION in the SQL
2. Execute the SQL without the OR part which will create the cursor. If the join criteria results in no records, you could APPEN BLANK.
3. Create the cursor yourself and APPEND FROM the main table, then set relations into the other tables and execute REPLACE commands