Re: DataEnvironment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cindy Winegarden (cindy.winegarden_at_mvps.org)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 10:41:03 -0500

In news: 209EBA3A-6E47-4918-95D1-AFA9B3D5A152@microsoft.com,
Marc Kayser <anonymous@discussions.microsoft.com> wrote:
> Hi Stefan,
> I found a solution that works.
> In the DE I set the property OneToMany = .F. of the first relation
> (Customers -> Accounts) although in my perception IT IS is a one to
> many relation, and I set the property OneToMany = .T. of the second
> relation (Accounts -> Years, as proposed by the DE) although in my
> perception this should be a Years -> Accounts relation, the many side
> is in the Accounts-table. I'm really puzzled about this.
> Seeing your example, I'm even more confused as you also Set the
> Relations from the One to the Many sides.
>
> Below, a short description of the DB's structure.
> Table Customer: Customers that are allocated a yearly grant, hence the
> Table Accounts: with the result of the yearly calculations depending
> on variables stored in this table and the
> Table Year: with group and yearly variables as the customers are
> member of one group
> Did you get the picture?
> Thanks
> Marc

Hi Marc,

Try opening your two "parent" tables in the VFP IDE and setting the
relations manually. To do this you'll need something like this:

Use Customers In 0
Use Years In 0
Use Use Accounts In 0 Order CustomerID

Select Customers
Set Relation To CustomerID Into Accounts
*-- So far so good

Select Years
*-- Set Relation To Year Into Accounts

To accomplish the line above you need to set the order of Accounts to Year,
but it's already in CustomerID order for the relation with Customers. You
could set the relation while Accounts is in CustomerID order, assuming both
CustomerID and Year are numeric and VFP won't complain, but you won't get
good data. 

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org  www.cindywinegarden.com

Relevant Pages

  • La merde de newportman
    ... IT WAS ONLY £233,000, and it was only about 20 British customers who ... Bangalore call centre had fiddled accounts and helped himself to ... the bank says they caught the crooked employee before he had ... Accountants Finance Terrorism - and Why Governments Can't Stop Them ...
    (rec.travel.europe)
  • Re: Show-stopper Exchange problem
    ... We're a bunch of engineers supporting a small number of very large customers, and there are multiple support aliases that we use: ... With pretty much any regular old SMTP server, this is trivial: the display name is controlled by the client, and the engineers just configured multiple "Accounts" in Outlook to contain whatever they wanted, but Exchange fills in the Display Name to be whatever is in the address book: this means that the recipient can't tell without opening the message which engineer sent it. ...
    (microsoft.public.windows.server.sbs)
  • Re: The Book
    ... > The editors portion of the book has been in my hands. ... Here is what the hackers are doing and how they are using your ... resources at your expense and your customers expense. ... accounts were closed, showing closed accounts are accessible when they ...
    (alt.computer.security)
  • Re: FT: Almost 20,000 close First Direct accounts
    ... Almost 20,000 customers have closed bank accounts at First Direct ...
    (uk.finance)
  • Re: The Book
    ... > The editors portion of the book has been in my hands. ... Here is what the hackers are doing and how they are using your ... resources at your expense and your customers expense. ... accounts were closed, showing closed accounts are accessible when they ...
    (comp.security.firewalls)