Relationship Issues

[Guest]

I have a relationship issue. Can someone help me???

I have a Company Table
Company Client Table
Company Client Product Table which ties back to the Company Products table.

When I write a report, I am getting ALL the rows from the Company Products
table...just not the row I need....ALL of them.

If this is too vague, I can explain further.

PLEASE HELP A NOVICE!

Thanks!

 

[Larry Daugherty]

How about including a name and description of the first few fields of each
table, including Company Products?

"Ties" isn't a meaningful verb in Access. Do you mean " is Related"?

It would probably be helpful to include the names of all of the tables in
play.

HTH

 

[Guest]

Larry,

Would it be possible to contact you directly???

 

[Guest]

Build a query to display the information you want to see. Then build your
report with that query as your data source, not the tables.

hth,
JMorrell

 

[Larry Daugherty]

Hi,

The idea is that you post the issue here and we address it here so that
everyone can see what the problem is and what was done to solve it. Don't
worry about being embarrassed about exposing your ignorance or
mis-apprehensions. We're all ignorant of some things and often mistaken or
misinformed.

Whether we do it here or by private communications it still requires the
information I asked you to supply. We need to know the purpose of each
table and its name and the names and types of the first few fields in each
table. In addition, I'd like to know about that last relationship.

Aside from the information sharing aspect, by keeping it in the newsgroup
there is always the chance that someone else will understand your issues
sooner or better than I. They could have solved your problem while I'm off
schmoozing the mall.

So, let's try once again here. If we make no progress we can take it off
line, solve it and post the results back here.