Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

When I create a detail record I see the record-picker field, an address, as it appears in the master. When I change the record picker field to read-only I only see the record number. Can I make the address value appear when it is read only?

The reference field (aka record-picker field) in the details table when displayed read-only always displays the value of the key field in the corresponding master record. The key field in the case you cite above is the Record ID#. To display the address value from the master record that you see in the record picker you'll need to place a lookup field that looks up the address field in the master record. On the form you should place the address lookup field next to the record-picker field. In the custom form designer set the record-picker field's "Display when this form is used for:" property to:

editing only

set the address lookup field's "Display when this form is used for:" property to:

displaying only

Now the address field will display when the form is used for viewing and editing.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit