Friends,

I am trying something really simple and can't get it to work. I'm
missing something very basic it seems. I am a power user and have been
using paradox for years.

Trying to link (for airport shuttles):
(Parent Table)
Shuttles.db with "Shuttle Code" as Key.
Includes "Last Name" and "First Name" fields for the driver.

with
(Detail Table)
Drivers.db with "Last Name then First Name as Key.

I want to link these on "Last Name" & "First Name" so there is a
one-to-one relationship.

I also want to have two table frames on my form, one for each table.

If I only link on "Last Name", all is fine. If I link with both "Last
Name" and "First Name" I cannot define fields in Shuttles' table frame.

I actually got this to work but changed something along the way in one
of the two tables (i.e. restructuring). When I open that form I get a
message that it can't open Drivers since an index is missing. I open
anyway and get all to work (i.e. two table frames that behave properly).
But if in trying to deal with the index problem, I go into design,
unlink drivers and relink it, or remove and reinstall the table and
relink it, fields become undefined.

Help!

Pete