Charles,

>I've look into this and someone suggested to be using an Active Server Page which would check the users table, discover what departments the user has control over, then so to the project table and see what active project there are and display them on the intranet page.
>
>How (if at all) would a com object be needed for this. Sorry for such elementray questions, but I am fairly new to this.

Sounds like you can get the data you need from one SELECT statement that pulls matching records from the project table for all departments assigned to that user.

You could do that in ASP, just using ADO to hit the Fox tables through OLE-DB driver for ODBC, with ODBC set up for Foxpro tables.

It could, of course, be done with a CREATEOBJECT on a Fox COM server, followed by a method call with user passed as a parameter. Your method would then get the data and return it as XML or as an ADO recordset, which your ASP would then iterate to construct an HTML table.

Or, your COM object could do ALL of the work and skip the XML/ADO part, and just SELECT the correct data and SCAN the cursor, appending HTML tags and data to a character string, which you could return to ASP. ASP would then just Response.Write that character string.

Or, you can.....

There are many other ways, including commercial web frameworks like FoxWeb and Web Connection, but they may be overkill for just a simple data page. If you're going to develop an entire application or lots of data-driven pages, you may appreciate the pre-built classes in Web Connection, which is my tool of choice.