Alright, let me see if I can spell this out correctly.I have two databases, one of faculty and one of courses.Faculty can be assigned to any and all courses. Courses have different contracts depending on how they're paid -- FT, Adjunct, and NCI, whic...

I am building a base of vendor records. Each record has a first name, last name, and vendor ID. Ideally, the unique ID would be the primary field. However, when using the "linked records" field in other tables, I have to enter the Vendor ID, which I ...