|
I am building a ticketing system and am stumped. I am using access as the database and have 9 tables connected through relationships. I have 1 table called "tickets" where 2 of the fields are "Opened_By" and "Closed_By" both pointing to a "Rep" table. If I use 1 of the relationships it works fine. Is there a way to use both in the same SQL statement? If so, how would I designate which ones I'm referring to when I write "Rep_First_Name"? Thanks for any help.
... And Happy Holidays.
|