I am having a problem with lookup forms. The senario :
I have a list type form which contains 3 feilds. Customer Id, Customer name and ship to address code from 'Ship-to Address' table.
When user will select a customer then corresponding customer name will automatically populated to the next grid/cell. When the user will click on the lookup window of the Ship to Address cell then a pop up will open with 'Ship-to Address List' form. Upon selecting a record it will update the cell with the ship to address code.
Everything is working fine except I am getting a message 'Do you want to rename the record ?'. This is occuring due to 'Ship-to Address' code.
My table structure for the form is
Enabled Field No. Field Name Data Type Length Description
Yes 1 No. Code 20
Yes 2 Name Text 30
Yes 3 Code Code 10
Yes 4 Misc Text 30
where primary key is (No. and code) feild.
Also I want to filter ship to address list box according to the selected customer record.
Thanks in advance.