create data test create table one (id i primary key, ctest c(10)) create table many (id i, ctest c(10)) index on id tag id alter table many add foreign key tag id references one tag idCandidate keys are created using the Candidate keyword in the INDEX command (tables do not have to be in a database to have candidate keys)., e.g.,
index on id tag id candidateIf you already have a database, run GenDBC (or GenDBCX) - it comes with VFP - against it. Throw all the goodies you can into the database (pk's, fk's, relations, stored procedures, etc.) and learn from the GenDBC output file how to handle each thing.