Hi,
I have a table with the following fields:
ResourceID
ResourceName
DateTime
InstructorID
LocationID
Misc
I have 2 different combinations that need to be unique: DateTime & InstructorID, and DateTime & LocationID.
I was going to make a combo key of DateTime, InstructorID, and LocationID...
I am trying to use a combo box to show a list of values from a table where the SysID is the same as the IDCode of a different table (of the record currently being displayed). What is the best way to do this? I tried using the following query:
SELECT Table2.Description
FROM Table2
WHERE...
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.