Display multiple tables in a grid?

Display multiple tables in a grid?

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 208.49.174.41] 'Jeff' on September 13, 2001 at 18:59:02 EST:

Hi,

Im trying to display rows from two tables in a single grid. Originally I was using a union to do this, and it was actually working. While testing I realized that a Contract (key of table one) can have multiple Invoices (key of table two) and that the Invoice # can be the same number as another Contract (a contract I am not trying to process), therefore, there are situations where Im pulling in extra, invalid lines. Is there another way to do this? Its crunch time now, any help would be greatly appreciated.

Thanks,
Jeff

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hi, : Im trying to display rows from two tables in a single grid. Originally I was using a union to do this, and it was actually working. While testing I realized that a Contract (key of table one) can have multiple Invoices (key of table two) and that the Invoice # can be the same number as another Contract (a contract I am not trying to process), therefore, there are situations where Im pulling in extra, invalid lines. Is there another way to do this? Its crunch time now, any help would be greatly appreciated. : Thanks, : Jeff