Hei!

I have to tables; tblProdukt and tblBestilling. TblProdukt has cell
p1, p2 and p3. TblBestilling has cell b1, b2, b3 and ProduktName.

How can I have two tables held open at the same time and what would the VB-script be?

SELECT * from Produkt AND Bestilling WHERE Bestilling.ProduktName = session("ProduktName"),

And here comes (in words) my query;

is tblProdukt.p1 = tblBestilling.b1
AND
is tblProdukt.p2 <> tblBestilling.b2
AND
is tblProdukt.p3 = tblBestilling.b3

The result of the query is then to be %= on a page when some update-button is moused on!

Thank you for reading and any answer you maight have.

Med vennlig hilsen

grstad

__________________
Internet has become favorable with that tool...thank you Tim Berners-Lee!