> If I understand, I think the answer you need is calculated fields. > > Your relatives panel has to have a key to the records in the Master > Information Panel. Then it apparently has fields for the other > information for each relative selected. If those fields were > calculated fields, they would always match the information desired in > the Master Information Panel.
Calculated fields is indeed a nice idea which I actually tried doing but somehow it didn't work, perhaps because I didn't set it up properly. Can you please help me with it? Malkie > > FWIW, that also avoids bloating the data base with repetitions of > addresses and phone numbers. > > Don Codling > 900 Old Sackville Road > Lower Sackville, NS B4E 1R1 > > On 11/10/2010 8:14 AM, [email protected] wrote: > > Hi Brian and Mark; > > > > Thank you so much for responding. Brian, I don't think it's a > > template or a formula I would need. All I want is that records in a > > Data Link of a panel linked to the source panel get updated > > automatically when the source information changes. As simple as > > that. > > > > There is only one source of address information and that's in the > > Master Information (MI). The MI has one Panel Link, let's call it, > > Relatives. The Relatives panel includes a Data Link targeting to the > > MI from where it selects any number of records. My question is how > > to get those records that were selected via the Data Link (from the > > MI) to be automatically updated? Here's an example: > > > > I'm in Master Information and go to John Doe. I click on his Panel > > Link which brings me to Relatives. Now I'm in the Relatives panel > > and go to the Data Link and select records (all of which are taken > > from the MI). I select Ann and her address and phone come along and > > automatically get entered in the appropriate fields created in the > > Relatives panel. Then I select a new record, namely David, and all > > his data comes along and are automatically entered in the Relatives > > panel fields. I do the same for Morris and Betty. > > > > My question is if David's address has changed or if Betty's phone > > number has changed in the main panel (the Master Information) how do > > they automatically get updated in John Doe's Relatives panel? The > > Cascade On on the Panel Link in the MI only works for any update on > > John Doe himself and not for any of his Data Link records. > > > > I hope it's clear now. > > Malkie > > > >> 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 > >> > >> > >> How many database panels are involved? In a normalized database > >> with multiple panels there should be only one source of "address > >> information" which when changed is the only place necessary to > >> change. Perhaps I misunderstand the question. > >> > >> Best Regards, > >> > >> Mark > >> > >> > >> > >>> From: [email protected] > >>> To: [email protected] > >>> Date: Sun, 10 Oct 2010 20:09:36 +0200 > >>> Subject: Re: [Dataperf] A Challenging Problem > >>> > >>>> Create a panel link (I call it a "recursive panel link for auto > >>>> data changes"), using fields needing changing in the index for > >>>> the link, with cascade on then hide it. This should give you the > >>>> functionality needed. > >>> Hi Mark; > >>> > >>> I'm trying to understand your idea. Are you suggesting to create a > >>> panel link from the Master Information or from the 2nd panel, the > >>> one that's linked to the MI and has a Data Link to the MI? And > >>> then what? What records should that new panel link include? Will > >>> the Data Link get the records from this new panel? The MI has > >>> cascade on too. What will this new panel accomplish? > >>> > >>>> Best Regards, > >>>> > >>>> Mark > >>>> > >>>> > >>>> > >>>>> From: [email protected] > >>>>> To: [email protected] > >>>>> Date: Sun, 10 Oct 2010 12:39:48 +0200 > >>>>> Subject: [Dataperf] A Challenging Problem > >>>>> > >>>>> 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 > >>> > >>> _______________________________________________ > >>> Dataperf mailing list > >>> [email protected] > >>> http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > _______________________________________________ > > Dataperf mailing list > > [email protected] > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
