SYMPTOMS

When using MS Access database, the fields that are foreign keys are not displayed as a drop-down list but as a normal textbox.

CAUSE

The MS Access system database table  MSysRelationships  stores the meta information for the table relations. smartDBforms.NET uses this table to determine which fields participate in foreign key relations. By default this table is configured as not accessible.

Also only foreign key relations that are marked as "Enforce Referential Integrity" are considered.

RESOLUTION

Make sure the MSysRelationships system database table's security settings allow read access.

Assure that the foreign key relations has the "Enforce Referential Integrity" checkbox selected in the MS Access Relations tool.

See Working with MS Access in the online documentation.

APPLIES TO

• smartDBforms.NET 1.4 and later( MS Access is not supported in the prevous versions ).
• MS Access databases