Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Larry Crumbie
  Where is Larry Crumbie?
 Ocho Rios
 Jamaica
 Larry Crumbie
 To: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 Tags
Subject: RE: one to many ... add info required
Thread ID: 508 Message ID: 519 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Saturday, June 02, 2001 9:17:07 PM         
   


> > Before too much effort could you tell me if the following is possible
> >
> > I have table #1 which is a categories table
> > Table #2 is an inventory line item table
> > Table #3 contains purchase orders relating to items in table #2
> >
> > I need to be able to use table #1 to organise the category order in which the inventory items print( and this works fine)
> >
> > But I need also to be able to print the purchase orders from table #3 which relates to the inventory items in #2 (This doesn't work, only the first Purchase order prints) mind you the relationship works fine if I take table #1 out.
> >
> > Question is what I'm trying to do possible or am I just doing something wrong.
> >
> > Hellp If this doesn't work I'll have to do it another way but won't look the way I want it
> > Larry, Jamaica
> Hi Larry,
> I think you will need to explain how you are doing what you are doing (query, report or form DataEnvironment etc) and with what (VFP5 or 6) ?
>
> Looking forward to more info
>
> Regards
> Ryss

Hi Ryss:

I'm using vfp6 and what I'm trying to do above is print a report. the report form has it's own data environment and the relationships are setup there.

Regards

Larry, Jamaica

ENTIRE THREAD

one toi many Posted by Larry Crumbie @ 6/1/2001 9:21:50 PM
RE: one to many ... add info required Posted by Ryss Unger @ 6/2/2001 5:14:50 PM
RE: one to many ... add info required Posted by Larry Crumbie @ 6/2/2001 9:17:07 PM
RE: one to many ... add info required Posted by Ryss Unger @ 6/3/2001 4:12:16 PM
RE: one to many ... add info required Posted by Larry Crumbie @ 6/5/2001 8:37:44 AM
RE: one to many Posted by Ryss Unger @ 6/5/2001 3:52:38 PM