# Database diagrams " Find lookup table"

**URL:** <https://forums.toadworld.com/t/database-diagrams-find-lookup-table/6823>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [August 26, 2011, 3:36am UTC](https://forums.toadworld.com/t/database-diagrams-find-lookup-table/6823 "2011-08-26T03:36:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mb.sharma\_515](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@mb.sharma\_515](https://forums.toadworld.com/u/mb.sharma_515)\
**Post date:** [August 26, 2011, 3:36am UTC](https://forums.toadworld.com/t/database-diagrams-find-lookup-table/6823/1 "2011-08-26T03:36:04Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [August 30, 2011, 9:43pm UTC](https://forums.toadworld.com/t/database-diagrams-find-lookup-table/6823/2 "2011-08-30T21:43:25Z")

</div>

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
