|
06-21-2006, 01:31 PM
|
#1 |
|
Junior Member
Join Date: Jun 2006
Posts: 1
|
Link tables for sub-reporting
I have several MyISAM tables that I am trying to link to do some invoice-type reporting (with sub-groups). In the data window, Navicat is not allowing me to establish links with fields which are integers (unsigned). This is a problem because all of my primary and foreign keys are integers -- which makes it impossible for me to do the joins which I need. I can link varchar fields but not integers. When I click the link button the integer fields do not even appear on the table of possible options. Am I missing something obvious? Thanks for your help. - Chad
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Foreign Key too Two Tables | jstephens | Database Design | 2 | 02-24-2006 07:11 PM |
| Populating MySQL Memory Tables | martman | General | 1 | 11-24-2004 08:26 AM |
| 1.2.4 How Big MySQL Tables Can Be | Administrator | Documentation | 3 | 10-21-2004 12:38 AM |
| 3.4 Getting Information About Databases and Tables | Administrator | Documentation | 0 | 06-25-2004 01:27 PM |
| 1.8 MySQL Standards Compliance | Administrator | Documentation | 21 | 06-08-2004 03:18 AM |
