i can't do a simple table lookup -- "higher table level required"

[SpaghettiStraps]

i can't figure out why i'm getting the "higher table level required" message when i try to do a table lookup.

i have a table "Awards" which has a non-keyed field:
Type A2 (i've created a secondary index on it)

i have another table called "Award Types":
Award Type A2 (this is the primary key field)

when i try to create the table lookup i get the above message.

earlier i noticed that the driver for a few of my tables in the database somehow became "paradox ansi" while most of the tables are "ascii ansi". i changed the "paradox ansi" files to "ascii ansi" to make them all the same (using restructure). is this relevant?

thanks

 

[Langley]

Not sure - try removing the secondary index (unless you really neeed it for something) and name the two fields the same. If it still gives you the same message, add logical fields to the end of each table to raise them to a higher level, save them, then restructure to remove the fields. You can also change the settings in paradox to create new tables at the highest level by default.

Mac

"Strange women lying in ponds and distributing swords is no basis for a system of government" - Dennis, age 37

mailto:langley_mckelvy@cd4.co.harris.tx.us

 

[JoeNg]

A wild guess is one or more of your tables was created by a different version of Paradox. I would make sure they are all created by the same version of Paradox.

 

[Lewy]

This question has been answered before. You need to do a keyword search on 'Lewy' as the author. There you will find all the answers you need. As ever 'Footpad' got me out of trouble.

Regards,

Lewy

 

[footpad]

SpaghettiStraps,

It sounds like either the IDAPI.CFG (or BDE.CFG) file has been overwritten or lost. If you previously configured BDE to specific settings, you'll probably need to reapply those settings using the BDE Administrator in Control Panel.

I think Lewy's referring to [thread177-217820] (Javascript required), which contains a broad range of tidbits along these lines.

Hope this helps...

-- Lance

 

[ros]

I don't know if this is causing to your problem, but I'd avoid using "Type" as a field name. This is a keyword and might be confusing the issue.

Richie

"Supreme executive power derives from a mandate from the masses, not from some farsical aquatic ceremony." - also Dennis

 

[SpaghettiStraps]

well, i tried everything but nothing worked. finally i just exported the two paradox tables causing the trouble to excel and deleted the paradox tables. i re-impported the data back into paradox tables and reassigned the primary keys and field names. my lookup works flawlessly.