Diagrams

Table

Cont. Duplicate Search String

DynamicsDocs.comCont. Duplicate Search String«Table 5086»Cont. Duplicate Search StringContact Company No. [PK,NN]Field; [Name,Name 2,Address,Address 2,...Part of Field; [First,Last] [PK]Search String«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...<Contact Company No.><Company No.><Lookup Contact No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Contact Company No. (Contact Company No.) Code20 NotBlank: Yes
2 Field (Field) Option
3 Part of Field (Part of Field) Option
4 Search String (Search String) Text10

Keys

# Fields
0 Contact Company No.,Field,Part of Field (Contact Company No.,Field,Part of Field) Clustered: Yes
1 Field,Part of Field,Search String (Field,Part of Field,Search String)

Table Relations To Other Tables

Field Related Table Related Field
Contact Company No. (Contact Company No.) Contact () 1..n

Table Relations From Other Tables

From Table From Field