Linked tables result in missing fields

[BasilFawltytoo]

I have two tables linked by the field "AccountNo". Table A contains all primary contact info. For every contact in the database there is one row in Table A. Table B contains supplementary contact data. For every contact there may or may not be an entry in Table B. Let's suppose I have two contacts: Bob and Doug. Bob has info in both tables, Doug only in Table A. When I create a report of all contact info in Table A Bob and Doug both show up. As soon as I add a field from Table B Doug dissapears. I still want Doug to be in the report, just with no info in the fields from Table B. So... when Table B has no corresponding "AccountNo" field to Table A, then none of the fields appear in the report. I don't know how to fix this.

 

[Hm786]

Hi,
Use outer join instead of regular equi join.

Thanks,
Hamida

 

[synapsevampire]

It's probably a join issue. Right click the line (link) between the two tables and select Options->Left Outer Join.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[BasilFawltytoo]

That's it! You guys rule! Thanks.