Hi Malkie
I am a little lost with what you are trying to do, however in response to
your reply to Don, there is a very flexible thing you can do with DP which
would spin the head of a programmer for a modern database, in that you can
have multiple panel links (or datalinks) on a panel and then use formula
logic to choose which link you will use to retrieve data. It means a Foreign
Key can variably relate to different panel's or even the same panels Primary
Keys. The auto-number recursive link uses this.
I also used it once to overcome a limitation I had created, (due to some
earlier poor planning) where I later needed to consolidate invoicing
information based on work being produced in multiple independent panels.
I am not sure of the recursive nature of your data. Is it so you can pull
back contact information using another record as a template, eg for family
members with the same address and phone number? If so you do not need the
Panel Link but can do it with a DataLink. For example if you were wishing to
create a copy of the address from another person in the same table, you
would create a field who's format matched the data format of your Primary
Key. On this field you would place a recursive DataLink, to bring the ID of
the template to copy from back to the record you are working on. In the
fields that you wish to copy the template data, create a Formula set to
trigger on any change. You can choose whether you want these to update
whenever the parent template changes, or to keep existing data, depending on
whether whole families are more likely to move addresses or children leave
the next
Eg to keep existing data or to allow overwriting of data the formula in say
P1F5:IF len(P1F5) THEN P1F5 ELSE P1F12P1F5 ENDIF
where P1F12 is the template_to_copy field with a DataLink back to the
Primary Key in P1F1
But perhaps you want something entirely different.
Brian
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, 11 October 2010 4:30 AM
To: [email protected]
Subject: Re: [Dataperf] A Challenging Problem
Hi Don;
Thanks for your response. It's more complicated because it's not a
one-to-one relationship. Every Panel Link can include several records.
It might be helpful if I mention that each record has a fixed ID
number that cannot be modified or changed. I was thinking something
along this line: The Data Link should only be linked to the ID of the
Master Information which would somehow get the rest of the data
(address and phone number) from another panel or perhaps a
'window' somewhere? I can't figure it out. Any input on this idea?
Malkie
> Good morning Malkie. I'm assuming that the master information data
> changes as you import new sets of records, ie. telephone book entries,
> and that the problem is that as the MI record changes your other panel
> has no way of knowing it. If we can assume that the link is a one:one
> link (ie. John Doe at 11 Maple St versus all John Doe's) then I would
> think you would use a formula in the display to simply show the data
> from the linked record; the formula would go through the link. If it's
> not a one-to-one link then it's another story.
>
> Don
>
> On Sun, Oct 10, 2010 at 6:39 AM, <[email protected]> wrote:
>
> > Hello to all those who love a challenge;
> >
> > I've been doing DP databases for tens of years but never came up
> > with the following:
> >
> > In this database there is the Master Information which includes
> > thousands of names, addresses, phone numbers, etc., as well as a
> > Panel Link targeted to the same panel. In other words, let's say I
> > would go to John Doe, press on the Panel Link and select names,
> > addresses and phone number from the Master Information via a Data
> > Link. This works nicely.
> >
> > My question is if any of the people that were selected in John Doe's
> > Data Link has an address or phone number change, how does it
> > automatically change in John Doe's panel if there's no Cascade
> > On/Off option with a Data Link?
> >
> > I thought I'd be able to solve it with a 'window' but apparently
> > Data Links do not have windows.
> >
> > Anybody out there with a brilliant idea how to select the
> > information from the Master Information and have it automatically
> > updated?
> >
> > Malkie
> > _______________________________________________
> > Dataperf mailing list
> > [email protected]
> > http://lists.dataperfect.nl/mailman/listinfo/dataperf
> >
>
>
>
> --
> Don Friedman
> ProfessionalRecords.Com LLC
> PRS Data Systems
> 205 S Main Street
> Pittsburgh, PA 15215
> 412-784-1600 - 1-800-PRS-FILE
> 412-784-1615 Fax
>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
