At 08:33 PM 20-01-02 -0800, Dion wrote:

>Hi Helen,
>
>>KeyLinks:-
>> TITLEID=/* QRYMEMBERBEN */BENEFICIARY.TITLEID
>Would this not effectively link the Title lookup dataset to the Beneficiary
>dataset instead of MemberBen? Would the KeySource for the above KeyLinks be
>dsMemberBen or dsBeneficiary?

I don't know. Which one is the datasource for qryMemberBen? That's the one that should be the Keysource.

I don't know enough about your structures to know how to get unique KeyLinks. All I could see from your original was that they weren't identified (and therefore were ambiguous) and that, with the selected columns, afaict, you have either non-uniqueness or redundancy.

btw, in case you didn't already work this out - if the updateSQL doesn't reflect the Keylinks, you won't get a live dataset (I believe). And, if the dataset can't go live, the dropdown won't work (it only works in Edit mode).

Sorry, Dion, I'm going to have to leave this thread now, and get on with my own workload.


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com