Solving one to many relationship between two tables

[ppatel2]

Software used:

Crystal 8.0
Microsoft Access Database

So I've linked two tables togethers. Table(A) has a one to many relationship with table(B). I've used data from table(A) in 4 out of the 6 columns in my report. Table(B) supplies 1 out of the six columns in my report. I've linked table Table(B) to table a with a field that I'm using as a group. The problem that I am having is that Table(B) data is affecting my output in the four columns of data from Table(A). I'd like to limit the scope of Table(B) to just that one column and make sure that it does not affect the output from Table(A).

The report looks like:

Row 1 w x y z o e
Row 2 a b c d i u
Row 3 f g h j v aa
Row 4 k l m n bb cc
Row 5 p q r s dd ee

 

[ppatel2]

My apologies, I linked the two tables using a key field from table(A) with a foreign key field (can have duplicate values) in Table(B). I did not however link the two tables on the field i'm using as a group.