October 11, 2010 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. 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
