form doesn't show what I choose in combo box

[Smoki]

Hi,
I have problem with my form. I have combo box, which Row Source is one table
(Equipment type). Data from that table are in other table (Register).
I want to choose one of the Equipment from that table, using combo box, and
then with query to find that records in Register table and to show all that
data in my form.
But I have problem. It doesn't work. Query is OK, I check it, but when I
choose something in combo box, nothing 's happen!
Problem is maybe with Relationship. I made simple Relatonship, but it can't
be One-to-many, because in Register table I have more Equipment's type then
in Equipment type table. And I don't want to put all of them in Equipment
type table, just some of them.
Can I do it somehow???

 

[Arvin Meyer [MVP]]

You cannot build a relationship without ALL the values on the one-side
table. Any join made will only show the values that are in the one-side
unless you take those values from the many-side, so you need to limit the
duplicates and use the Equipment table like:

Select DISTINCT EquipmentType From tblEquipment;

 

[Smoki]

But, those many-side is in tblRegister, and I don't know how to make form in
that case. I tried with form with subform, but when I choose value in combo
box, nothing 's appear in subform.

 

[Arvin Meyer [MVP]]

The rowsource of the combo box does not have to be from the same table:

Select DISTINCT EquipmentType From tblRegister;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Smoki]

I know that about rowsource. But, I probably didn't explain good. In
tblRegister in Column EquipmentType I have, for example 10 types of
equipment, and some of them appear several times. In tblEquipment in Column
EquipmentType I have only 5 types of equipment. And I would like to do this:

Select EquipmentType From tblEquipment;

and to show all rows from tblRegister where that EquipmentType appears!
But, it doesn't work! Maybe it's because of Relationship. I couldn't create
one-to-many relationship, using tblEquipment and tblRegister, because I don't
have all different values from tblRegister in tblEquipment.
Do I explain this better now? I hope I do

So, what to do?

Smoki

 

[Arvin Meyer [MVP]]

This SQL statement will select all the rows in tblRegister that have a match
to the combo box value. I am assuming that you have the long integer
datatype as the bound value in the combo box:

Select * From tblRegister Where EquipmentTypeID = &
Forms!FormName!cboComboBoxName

Substitute the correct names as necessary.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com