I'm using VFP 5.0 to connect to MS Access Database. I have created a primary key and foreign key in MS Access for 2 tables. The relationship of these 2 tables is 1 to many(parent and child).

Now I want to build a program consists of these 2 tables, so I created a remote view for each of these tables. When I add these 2 remote views in the data environment of the form. I'm not able to set the relationship of these 2 tables.

Anyone has any idea, what is the best way to build a parent and child relationship program using remote view in client/server enviroment?

Thank U in advance.