>I have a database that has 2 tables in a 1-to-many relationship. It is indexed on location. When the user inputs a location, I want to make sure that location is not already in the parent table. Is this possible? I am new to VFP, so the more detailed the better. Thank you in advance.
>Bob Sides.
if the index is either primary or candidate, vfp won't let you save a record with a duplicate entry. it is better to check this before you get to this point however.