See if this sheds some light on the problem... I did a search subroutine in SQL.   It uses two or more tables, A primary data will call CustomerT and a secondary Table for additional info.  If data is in the primary and secondary Tables.. all is fine.  But if ONLY THE PRIMARY CustomerT has data but the secondary IS NULL then the search results shows nothing.  What can I do to still force it to show up in the listbox results? In a previous lesson I think I took do you know where you can point me?
Thanx

---

Reply from Alex Hedley:

This will be to do with your JOIN.
When you have joined the two tables, double click the line, this brings up a box.
You can show records where they match or show records in one table, or the other.