MOD2000: Lookup Tables Are Actually DX Type Instead of DL Type

• Microsoft Office 2000 Developer

SYMPTOMS

When you add a main table, lookup tables are also added to the Access Workflow Designer Object list, because the lookup tables participate in the "many side" of a one-to-many relationship with the main table. These tables are given a DX object type. However, the "The modObjects Table" and "The modObjectTypes Table" Help topics say that lookup tables have a DL object type.

CAUSE

The "The modObjects Table" and "The modObjectTypes Table" Help topics incorrectly refer to DL object types for lookup tables. These Help topics should refer to DX object types for lookup tables instead.

RESOLUTION

The Help topics are incorrect. Use the DX object type information instead of the DL object type information.

MORE INFORMATION

Steps to Reproduce Behavior

1. On the development computer, open a registered database in Access Workflow Designer.



2. Expand the Tables node.



3. Expand a main table until you locate a lookup table (for example, the Jobs table is a lookup table in the pubs database if the pubs database has been registered and the Employee table is the main table).



4. Open Microsoft SQL Server Enterprise Manager.



5. Expand the registered database.



6. Expand the Tables node.



7. Right-click the modObjects table, point to Open Table, and then click Return all rows.
   
   Note that the Type column displays DX for lookup tables.

Additional query words: pra

Keywords : kbdocerr kbdta accwfdesigner modWFDesigner
Version : :
Platform :
Issue type : kbbug