Michael,
I think there was some way to selectively lock a link using DPMouse, but
I've never really used it so I can't say for sure.
Otherwise, there isn't any way to make a data link work only for certain
records.
However, maybe you could do some processing on the back end of the link in
panel 2 so that if the user is trying to post payment information for
someone who isn't an Advertiser, it won't allow the record to be saved. I'm
thinking of something like a hidden field that maybe autoincrements only for
good records (i.e. Advertiser payments) but doesn't increment for others.
Then an index on this field so that a non-incremented value creates a
non-unique record, preventing the user from saving it.
Something like this would be a little tricky to set up, but it should work.
However, it's not really user-friendly because the error message comes after
the user posts the payment rather than when they first try to go through the
link, and then the error message is kind of cryptic ('record not unique'
instead of 'hey dummy - only payments for advertisers'), but it would
accomplish the purpose.
Another approach might be to rethink how the payments are posted. Instead of
letting the user link from Panel 1 to Panel 2, maybe have them go directly
to Panel 2 to post the payments. When they create a payment record they
would select the Advertiser's name via a data-link. You could use an index
with an exception field (in Panel 1) for the data link, which would only
allow them to select a name from records for Advertisers.
Tim Rude
----- Original Message -----
From: "Michael Iannantuoni" <[EMAIL PROTECTED]>
To: "Dataperfect Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, August 16, 2006 12:01 PM
Subject: [Dataperf] Selective Link
> Maybe I'm missing the obvious here or maybe it's been a while since I
> created a new DP application:
>
> I have a panel(1) containing, among other things, Names and a separate
> field of "A", "S" or "F" to show if this person is an Advertiser,
> Subscriber or receives a Free copy of a magazine.
>
> I need a second panel(2) containing the same Name to show payments made
> by advertisers and a link between the two but I want the link from panel
> 1 to 2 only to work for Advertisers.
>
> What is the best way to do this please?
>
> TIA
>
> Michael
>
> _______________________________________________
> Dataperf mailing list
> [email protected]
> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
