select statement

[jellybeannn]

This query is used to populate a ComboBox.

SELECT Model.mod_id, ( SELECT (Manufacture.manufacture) FROM Manufacture WHERE Manufacture.man_id = Model.man_id ) + ' - ' + Model.model + ' - ' + Model.imei_no FROM Model WHERE Model.mod_id<>Customers.mod_id;

I've got two problems with this query:
1. Model.imei_no, if this is included nothing is displayed, without it manufacture and model show.


2. FROM Model WHERE Model.mod_id<>Customers.mod_id; with this nothing is displayed even id's which is not in the customer table, they are a relationship

[NTC]

Are you making the query using query design?

[jellybeannn]

No, I'm making the query in the ComboBox Row Source.

[NTC]

As you self describe as a novice, I would recommend that you develop & test the query using query design. Save it with a name. Then make your combobox and source it on that query.

[jellybeannn]

Ok I'm very new to this so please bear with me,

The dropdown has to show the make, model and imei no.
e.g Nokia - S125 - 1234468

I tried creating it in the design view but when I call the query from the drop down only the model is shown.

[jellybeannn]

Ok I'm a step ahead.

The problem is that it is looking for a mod_id and a customer id. But I want it to show all the mod_id's where it is NOT in all of the customer id's how would I do this.