Database Reference
In-Depth Information
Figure 10.46. The current structure of the STAFF table
There is currently no means of associating a given staff member to other staff members
within the table; therefore, you must create a new field that will act as the foreign key and
enable you to establish the relationship. Let's assume you create a new foreign key field
called M ANAGER ID that will draw its values exclusively from the S TAFF ID field. You now
establishtherelationshipbyofficiallydesignatingM ANAGER IDastheforeignkeyandnot-
ating it as such in the relationship diagram. Figure 10.47 shows the revised relationship
diagram for the STAFF table.
Search WWH ::




Custom Search