Displaying a multiple tables recordset

Does ANYONE know how to display a record from a recordset which consists of multiple tables?I've already tried <font style="color:990000;">rs.fields("tablename.fieldname").value </font>and about a zillion other methods but nothing seems to work.please help!

In fact your code should read:

rs("fieldname alias")

Therefore:
SELECT c.ID AS ClientID, o.ID as OrderID FROM Clients c, Orders o ...

In this case this gives:
rs("OrderID"), rs("ClientID")

but rs("Order.ID") will fail

BTW forget about ".value" and ".fields". It seems to be faster (though, only in a loop) to not use it. It's the default props anyway and hence it is not necessary to browse all props (coz that's what it does) until the correct one is found. The same should be true for the fields collection. And in the end it's faster (and nicer) typing!