|
-
Jul 9th, 2009, 05:27 AM
#2
Re: Refer to same Id on table
The ManagerID field should be the same kind of data type as the EmployeeID field, but without the Primary Key and Identity properties set.
In terms of using it for queries etc, that is a little more complex. There is an example in the "SQL" section of the FAQs, but that is for SQL Server so may need tweaking to whatever database system you are using.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|