Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 To: Larry Crumbie
  Where is Larry Crumbie?
 Ocho Rios
 Jamaica
 Larry Crumbie
 Tags
Subject: RE: one to many ... add info required
Thread ID: 508 Message ID: 522 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Sunday, June 03, 2001 4:12:16 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
Hi Larry,
Great .. Yes it should work.
As a starting point ...

Think you just need to watch that the report follows the relationships. group header 1 = file1
header two = file2
detail = file 3

At leats thats what i think without sitting down with the actual data

Maybe test your relations ships in a form with grids for table1,2,3 and make sure they are all ship shape.

HTH as a start

Regards
Ryss

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