Thanks Gustavo,
I believe that what you have mentioned is what I am doing. Here are the steps I have followed.
- The field customer on my “master” invoice form, is an integer, linked to the customer file. I opened up the general settings for that field.
- I changed the data type field to Select.
- In the lookup settings section, I inserted the SQL select statement as
SELECT cu_id, cu_name
FROM customers
ORDER BY cu_name
- I then set up the link to a form_customer, with no parameters, and then set as modal.
- I ran the application, and the drop down list box appears with current customers listed, and an Edit button appears to the right.
- I click on the Edit button a “master” invoice form appears in the modal window and not the customer form.
So today, I deleted the link in the field settings, and added a link under the main link section to a grid, but to no avail (as was to be expected), so I deleted that link and went back into the field details once again, and added the link back to the customer form.
This time it worked. There was absolutely no difference to what I had placed in the field link settings before, but obviously there must have been some internal setting that got changed, where a normal edit of field link details failed to update it correctly. Whether adding the link to the grid (in the main link section) and then deleting it was the catalyst to fixing the internal settings I can only surmise, but it did the trick.
Tony