Merging Recordsets on same page

[sinistapenguin]

Hi All

I have a situation where I would like to merge multiple recordsets on one page. Basically I have 2 tables - Invoices an Credits, I am trying to put together a 'Statement' page which shows activity on an account by date.

So I would like to have something that looks like this:

INV1____ InvDate1____ Amount1
INV2 ____InvDate2 ____ Amount2
CR1 ____CrDate1_____CreditAmount1
INV3____ InvDate3_____Amount3
CR2____ CrDate2_____CreditAmount2

etc.

Is there any way of showing this one one page?

Any help greatly appreciated

Cheers

Sinista

 

[lebisol]

u would make a querry that JOINs both tables based on some realtionship....then DW will represent it as "1 table" ( Bindings-->Recordset--->...under 'Views' NOT 'Tables' )
I would suggest u do most of your SQL statements in DB vs. in the ASP/JSP/PHP/CFM/NET pages...
All the best!

> need more info?
:: don't click HERE ::

 

[Microbe]

That,of course is assuming a relationship exists in the tables.

If not, then you just open each table, find the record and display the fields you want to show.



Steve Davis
hey.you AT HaHaHa.com.au

http://www.HaHaHa.com.au/weblog

Me? I can't even spell ASP!

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination

 

[lebisol]

1 RS /repeated region per page is "navigational"...

> need more info?
:: don't click HERE ::