Hello,
My name is Juan Sevillano. I am desperetaly looking for HELP

I need to know if you could please help me.
I am currently using Dreamweaver MX 2004, MS SQL, ASP & Elite Accounting
Database System.
I am creating an intranet for my department. But I need to add a feature in
which I can enable
the department to see a copy of the invoice sent.

For instance: I have two tables. I need to link Invoice Number with an image
from a different table.
(Just like - when you check your bank account history. You have an icon to
see the image of the cancelled check)

I want to do the same thing. My table is in this way...

TABLE 1 TABLE 2
-Inv No................................Link Image (pdf file)
-Inv Date
-Amount

The person will have a page in which they'll have to search by invoice
number, click 'Search'
then the result (ASP) page will show:

Inv No. Inv. Date Amount Link Image
123456 8/30/2004 $1,000.00 View Invoice

So when they pressed on 'View Inv' a PDF file will be open in its own page
and show the invoice.

Q. - How can I link the two tables, so that my SQL statement will know that
123456.pdf equals Inv No. 123456

I would greatly appreciate if you could help me with this.
I thank you for your time and help on this matter.

Best Regards,

Juan Sevillano
Fried|Frank - eBilling Analyst
Direct: 212-859-4875