Building a recordset for multiple tables
I am looking for some guidance. I have a db that i have several tables in and i would like to build a recordset to show data from several tables in on. In this case i have a table for my users and i have rows in that table that hold the id to several other tables such as company type and company name. so my question is can i build a querey to compres three tables into one recordset for display purposes only.