relationships 101 please

[please help]

I have created two tables one called case participant and
the other called category. I can get a report showing
case participant numbers and information in that table but
I can not get it to put in the category ID number or
name. Can someone simplify the mystic relationship world
for me please! I have put in a field called case
participant in the Category table and tried a one to many
relationship setting (one from case; many from category)
by dragging the CaseParticipant to CaseParticipant in the
tables. Same with the other way around. Put alas my
reports still show only either the caseParticipant number
(which is the name and primary key) in that report
(participant) and my three categories by name in the
Category report but the caseparticipant is blank.
Can someone please help me out on this? Because coming up
is the Product table that contains products that are
associated to the categories which are both associated to
the participant.

 

[Tru]

Try this
Use the query wizard to select the information you would
like from both tables and when asked, Would you like to
preview the data? Click yes and this will let preview you
data in spreadsheet form. If your data is what you wanted
then create a report using the report wizard.

Hope this helps if not send me your table layout for
review and I will make the nessary corrections for you.

 

[Joseph Meehan]

I have created two tables one called case participant and
the other called category. I can get a report showing
case participant numbers and information in that table but
I can not get it to put in the category ID number or
name. Can someone simplify the mystic relationship world
for me please! I have put in a field called case
participant in the Category table and tried a one to many
relationship setting (one from case; many from category)
by dragging the CaseParticipant to CaseParticipant in the
tables. Same with the other way around. Put alas my
reports still show only either the caseParticipant number
(which is the name and primary key) in that report
(participant) and my three categories by name in the
Category report but the caseparticipant is blank.
Can someone please help me out on this? Because coming up
is the Product table that contains products that are
associated to the categories which are both associated to
the participant.

Follow Tru's suggestion.

One common problem is a mis-match of field types, for example one table
may have the double (a type of number) and the other table text. They both
may have and show 1, 2, 3, ... but there will be no match since they the
number "1" does not match the text symbol "1"