Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anthony Richards
  Where is Anthony Richards?
 kassel
 Germany
 Anthony Richards
 Tags
Subject: Many to many relationships
Thread ID: 15706 Message ID: 15706 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, September 27, 2002 5:22:36 PM         
   


I have the situation where many to many relationships exist between two table and I do not know how to build this link as follows:

Table one contains names
Table two contains documents

A document can ´belong´to one or many names

More than one document can belong to any name

Eg.
Doc1 ´belongs´to name1
Doc2 ´belongs´to name1, name2, name3
Doc3 ´belongs´to name2,name3
etc

I wish to display ALL the documents belonging to a single name in a form e.g.

Name1 in textbox and a table containing Doc1 and doc 2. I wish to ´move´(skip) on to name 2 and display doc2 and doc3 etc etc

Help appreciated. thanks in advance

Anthony

ENTIRE THREAD

Many to many relationships Posted by Anthony Richards @ 9/27/2002 5:22:36 PM
RE: Many to many relationships Posted by Yuri Rubinov @ 9/27/2002 8:09:19 PM
RE: Many to many relationships Posted by Erik Gomez @ 9/28/2002 4:34:46 AM
RE: Many to many relationships Posted by Adel Kadi @ 10/1/2002 2:51:33 AM
RE: Many to many relationships Posted by Erik Gomez @ 10/1/2002 8:25:54 AM
RE: Many to many relationships Posted by Adel Kadi @ 10/1/2002 10:52:44 PM