ENQUIRY

Hi all,

I have an issue like

Should be a valid DE.ADDRESS carrier and sequence for the customer. A dropdown enquiry will be provided to list all the address records for the customer under the carrier “PRINT”. The user can choose the record from the enquiry. If for a customer, there are three print address records says PRINT.1, PRINT.2 and PRINT.3 and the customer chooses PRINT.2, then this ID is to be captured here. The details of the address fields are to be listed in the dropdown to help the user to choose the address


how to achieve this.

Field No : Address
Column : 1
Text : DE Address
Drop Down : %DE.ADDRESS
Enq Selection : @ID LK '100300...'

This Eg is just to explain how the enquiry will only fetch in the dropdown all DE.ADDRESS records for the CUSTOMER record 100300

Some corrections to my earlier response.

Enq Selection : @ID LK '...100300...'

The ID of DE.ADDRESS start with the Company ID so it should no be '100300...'

Also make sure you have @ID defined in the Selection Flds in %DE.ADDRESS enquiry.

If you dont want to tamper with the %DE.ADDRESS enquiry then copy the %DE.ADDRESS enquiry into a new name and attach that in the Drop Down field for your Address field.

Here if i take ant customer.no lk 100300 it is diplaying the records.
while if i keep the field name as CUSTOMER.NO it is not showing any result.