Here's a picture of my relationships and the tables with their content fields that I have setup. If these are not correct or could be improved, let me know.
Scott Menzer
Venture Web Concepts
www.VentureWebConcepts.com
I have 4 tables that I need to join in a query. The tables have data like this:
TimeClock -> ClockID (PK), SiteID, WorkerID, TypeID, Start, Finish
Sites -> SiteID (PK), Name
Worker -> WorkerID (PK), Name
WorkType -> TypeID (PK), Type
I need a query that will take all the data from the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.