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
