set a combo with a information database

  • Thread starter Thread starter Muttley
  • Start date Start date
M

Muttley

Hi

I am Newcomer in Access, I would like to know How can I put a information
in the combobox from database , example:

Table A
Name
High
id_color


Table B
id_color
Name_color

I am fill information from Table A, when to get Id_color I woul like to set
combobox with name_color from Table B

How can I to do it ?
 
Hi,


I am not sure of your context, but a query can be used. In the query
designer, bring both tables, then, drag and drop id_color from tableB over
the same field, in tableA.

In the grid, bring all the fields from TableA and TableB.

You can switch from design view to data view to see the behavior.

Save the query.

Use the query, rather than tableA, for "source" of your form.


Hoping it may help,
Vanderghast, Access MVP
 
Bingo

Thank You
Michel Walsh said:
Hi,


I am not sure of your context, but a query can be used. In the query
designer, bring both tables, then, drag and drop id_color from tableB over
the same field, in tableA.

In the grid, bring all the fields from TableA and TableB.

You can switch from design view to data view to see the behavior.

Save the query.

Use the query, rather than tableA, for "source" of your form.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Back
Top