Disable new record lookup

[trackmanpete]

In AlphaSports the Invoice Form has a field "Customer_id" used to find customers from another table through a lookup process. When clicking on the field's triangle, one can change the customer when the lookup table opens. To enter a new invoice, there is a toolbar icon for a new invoice that also opens the lookup table, from which you can then select the customer that the new invoice is being created for.

The issue I have is that I wish to disable the customer id field that is located on the form, since it is possible to change the name of the invoice after creating the invoice, adding items and saving it. If one were to accidentally click on the field and change the name, that would not be a good thing, but that is possible with the AlphaSports sample. If I check off the disable check box, read only check box or hide the field for the "customer_id" field, the toolbar icon will no longer generate a new invoice and have the lookup table appear. It will only generate a new record, with no possible way of entering a new customer's id number.

I tried doing some Events code, but did not get anything accomplished with that either. Does anyone have any suggestions?

Thanks

[Keith Hubert]

Re: Disable new record lookup

Hi Pete,

Have you tried Skip in Field Rules?

[trackmanpete]

Re: Disable new record lookup

Keith:
Same results as the other attempts. This same issue exists in Quickbooks and has caused some confusion with data entries, so that is the reason I am trying to figure out how to override this.

[Tom Cone Jr]

Re: Disable new record lookup

Pete, to block edits when the customer_id field contains text you can do something like this in the

OnArrive event

for the Customer_id field

if alltrim(parent:customer_id.text) <> "" then
    parent:date.activate()  'block edits to field, by shifting focus away
end if

This will not block the normal functioning of the toolbar 'new record' button.

This is an illustration of technique. A more robust solution would include a field in the header record to flag whether ANY edits (at all) are permitted. The suggested script would be modified to look for the flag instead of just checking to see if the field contained text. Alternatively, the onFetch event for the form could check the flag and raise or lower the restriction on changes form wide.

-- tom

[trackmanpete]

Re: Disable new record lookup

Tom:
I went in a similar direction earlier today (tried about 10 different ways of fixing this), but no solution. I went to On Change and put in a "disallow edit" command, but that did not work. Should that not also work? I tried the same on On Arrive with same result.

Your suggestion does the trick very nicely.

Thanks again for your quick response.