Figure

Selecting fields for a unique record identifier index.

Select Unique Record Identifier

EH

Fields in table 'HumanRes

ources_vEmployee' :

EmploveelD

FirstName

MiddleName

LastName

Suffix

JobTitle

Phone

EmailAddress EmailPromotion AddressLinel AddressLine2

To ensure data integrity and to update records, you must choose a field or fields that uniquely identify each record, Select up to ten fields,

[ s. I

Cancel

!

16. Now, as in Figure 18.64, you can see the linked SQL Server tables in the Access database window.

FIGURE 18.64

Linked SQL Server tables in an Access front-end database.

FIGURE 18.64

Linked SQL Server tables in an Access front-end database.

With the tables linked, you can proceed to create the Access front end for working with the SQL Server data.

0 0

Post a comment