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


From your explanation I assume that you have duplicate names in table1 and you need to display one(name)-to -many(doc) relation. Then you should create a cursor/view having distinct names from table1 and then set one-to-many relations ans needed.

> 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