Combo Box Problems

H

Hugo Aguero R

I have a problem. I'm using access 2003 and I have a SQL database. I have
the sql tables linked to access via ODBC.

I want to make a form which have a combo box, this combo box reads the data
from a table called GRUPOINGREDIENTES.

The table GrupoIngredientes have 2 primary keys and have this structure:

sCodigoGrupo - text - 10
sDescripcionGrupo - text - 10
sNumeroRestaurante - text - 10
sCodigoDeafult - text - 10

The fields sCodigoGrupo and sNumeroRestaurante are primary keys.

When I make the combo box it shows me all the registers when it supossed to
show me only the linked field "sNumeroRestaurante" with the same named field
in the table original form.

This happens with every combo box who reads from a table with many primary
keys.

I try to find where to link the data but I haven't found it, there's no
LinkMasterFields property in this control. So please tell me how to do it or
if there's another way to do this please tell me.
 
Top