I am designing a form that prompts the user for an account number, then sets up a filter condition to bring only that one record to the form for editing. Some fields on the main table link to other tables, using combo boxes. The SQL source for the form includes linking the main table with the sub-tables as set up in my relationships. The problem is that the fields in the main table that link to the sub-tables are not always required fields. So, when I pull a record that doesn't SQL link to the sub-tables, I get nothing because the filter condition is not satisfied. I'm wondering if there is a better way to provide flexibility while pulling or linking from the sub-tables only when those linked fields contain data. Thanks.