|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.