>Is there a way you can set up permanent relationship between tables? either in VFP or VMP database container
>
>thanks.

Create a database and create your tables in it. Create primary, foreign keys and relate them.
See Testdata.dbc as an example.
Cetin