Have got a mini **** thing running.<BR>When items (for sale) are listed I'd also like to show which user is offering each item. The details about each item come from a table called items. In the items table is a field called sellerID which is a foreign key from the person table. I need to be able to grab the persons name from the person table. Here is my current SQL - any tips on the needed SQL please. <BR>strSQL = "SELECT * FROM Item WHERE ExpirationDate > #" & FormatDateTime(Now,2) & "# AND ItemStatus = 'Active' AND CatID = '" & request("CatID") & "'"