I created a stored procedure:

CREATE PROCEDURE GetAllEquipFacNameRecs
AS
select e.*, f.name as facname
from equipment e
left outer join facilities f
on e.facilid = f.id
order by e.cid

and ran it at the beginning of the application to load all my records into the dataset "Me.dsEquipment = Me.oEquipment.GetAllEquipRecs()"

This worked well to show the facility name as I navigated through the records, but when I went to save a changed record I got an error that indicated the dataset didn't match the table on the server, because of that extra field I suspect.

So maybe this isn't the way to do it, or I got something wrong in how to set this up.

Any suggestions?

Thanks.