combo box not showing all records - reference accross two tables

[bennybee]

i have a combo box which displays 3 values (number, name and subject), and when i select it only the number is displayed, which is what i want (the other info is just to make sure that the user is selecting the right record).

the number and the subject values are from the same table, but the name is from another table.

the problem is that the combo box is only displaying those results for which there is an entry in both the tables - ie. that there is a number and a name.
but not all records will have a name, but a subject, and i still want to be able to select this.

how can i get the combo box to show all the records even if there is a blank value in one of the tables (ie. a name is not entered for that record).

any help would be great
bb

 

[WayneRyan]

bb,

Base you combo on a query that has both tables. The
table on the Left has all of the rows that you want.

Right-click on the line "joining" the tables and look at the
properties. Choose Select All from the left table and only
those records from the right table where the joined fields
are equal.

Wayne