I have two SQL tables that are linked; a log table that has log information and links to a vendor list via the vendor name. The vendor table has the vendor names and addresses. I would like to create a report that prints all of the log information along with the vendor addresses for each record int he log table. How can this be done via a repeat region?

Currently it is set up so that the log table repeat region links to a details page. In the link I pass the ID and VendorName variables from the log table. In the details page, the ID pulls the log and the VendorName filters the vendor table for the address.

Thanks in advance for the help!


Edited by - maz2002 on 05 Dec 2002 16:59:12

I have not updated to MX yet but I do have DWUD 4. The way I handle this is to create a query in the database and when I establish a record set, I select the view section (view is another way to say query). This is very simple in MS Access and MS SQL. Not sure about MY SQL. My theory is the Macromedia product is a great user GUI interface developer and allows the programmer to easliy connnect to the database. The database strength is data manipulation creating record sets. So use both of these to your advantage.

Wm. Kent Steelman

Dear Maz2002,

msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_09_610z.asp

Regards,
Brent