I think I understand now. Calculated fields will work. However to answer your question. In your specific case you would create an index in the relative field which includes the fields you wish to be updated as the first fields in the index followed by fields required to keep the index unique. Then in the MI panel create a panel link to the relative panel use this new index and mark the fields in the Key fields list in the same orde as you placed in the index created in the relative panel including only the fields needing updating. Turn the cascade update on then hide the panel link. Now when you update any of the address fields in MI it will automatically update all related panels through the link created.
Best Regards, Mark > From: [email protected] > To: [email protected] > Date: Mon, 11 Oct 2010 20:26:17 +0200 > Subject: Re: [Dataperf] A Challenging Problem > > > 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
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
