Folks,
I'm creating a new local table - so far, so good.
My wrinkle is that I want one of the fields to hold the customer_no - I appreciate that I can have the TR_REFERENCE_COLUMN.dddw_description field show a value like lname + ', ' + fname + ' - ' + customer_no but is there any way of making the Constituent Search screen open up instead?
Does anyone else have an LTR_ table that holds the customer_no value? How do you make this work most efficiently for you?
Martin
Unknown said: Does anyone else have an LTR_ table that holds the customer_no value? How do you make this work most efficiently for you?
We have several. Customer_no columns are plain, old ints, nothing fancy. You don't say so explicitly, but it sounds like you are creating a custom table that is to be associated with an InfoMaker custom tab. From the Custom Tab doc:
If you want a constituent search chicklet next to a constituent id column, then place a text object with no text, a 3D Raised Border, and color ButtonFace in the detail band next to the data column. Call the text object IDNO_colname. For instance if the date column is called teacher_no, then the button should be called IDNO_teacher_no. If you want the chiclet to only be visible in the row currently being edited, then place this expression in the Visible Property Expression for the text object: If(CurrentRow() = GetRow(), 1, 0) (Added v3.30)