Toad World® Forums

Database diagrams " Find lookup table"

Menu option :- Tools > Database Diagrams.

It opens DB digrsam pallette.
The connection is made to EXCEL sheet.
As of now there are no relationships defined.
But there relation between EMP table and DEPT for DEPTID.
Both tables are dragged in pane.
DEPTID column on EMP table is selected.
Right click on dept. Select option “Find lookup Table” for the column DEPTID.

But it displays no table exist but DEPTID exists in DEPT table.

Plz help me if there is any more option or missing step.

Find look up table only works on tables that have RDMS defined foreign keys. It will not work in Excel and there is also a bug in 2.7.

Sorry.
Debbie