Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

constraints

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
I've to set up a test database using Groff tables&nbsp;&nbsp;Anyway, in inputting the Groff stuff I was going to create a constraint on the<br>Manager column of the Salesreps table. Reason behind my thinking - the manager<br>has an Empl_Num. The Empl_Num is the Salesreps pk. Want to be able to check the<br>manager against the empl_num. However, consider this - not every employee will<br>necessarily report to a manager, so I want to allow the manager column to hold a<br>null value where necessary. Can I creat such a constraint and if so how?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top