Re: Lookup fields in Dev2k

Not sure how you are trying to use it, but you should be able to user a Master-Detail-Detail relationship and when you create the second Detail, define your own relationship.

Kenny Gump
jaroslaw.c.pyszkiewicz_at_europe.eds.com wrote in message <77g7b7$ef6$1_at_nnrp2.dejanews.com>...
>This is design question. Trivial I persume (from beginner) I have column in
>table containing code. This code is described in look-up table. Now, how to
>present this field on form in a way similar to lookup combo box in Ms
Access.
>I'd like to be able to present this code in detail block in master- detail
>section (this is other relationship than with lookup). I'd like also to be
>able to keep this code in tabular block (detail section) without loosing
any
>functionality (insert/update/delete) and without much programming. Someone
>told me that this kind of presentation requires programming on form.
>Comparing to MsAccess where it is possible without coding any events, looks
>very cumbersome. Do I really have to create hidden fields and program dozen
>of events ?
>
>TIA, Jarek
>
>ps. Please reply on mail. I'm not using news very often.
>
>Jarek Pyszkiewicz, EDS Ireland
>jarek.pyszkiewicz_at_eds.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Jan 13 1999 - 14:00:09 CET