Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Can someone answer this?
Date:Sun, 15 May 2016 09:45:24 -0400
From:"Larry DiGiovanni" <nospam@nospam>
Liz McGuire wrote:

> You will need to index the FK, also, you can actually set up a foreign 
> key, which will like the tables, create constraints, and should speed 
> things up (but won't break things like in Paradox, unless you actually 
> need to break the FK rules).

The above comment reads (to me) that I can either create an index OR create 
a foreign key constraint.  Just to clarify, if an index on the FK column is 
required, you must explicitly create that index.  The foreign key constraint 
does not do this automatically.

Larry DiGiovanni

Copyright © 2004