Skip to main content

Hi,

We have a form (‘Workorder’) with a lookup to another table (‘container_number’). When the container_number is not found, you can’t save the Workorder. However, for almost every entry, we have to enter a new container_number.

Is there some way where we can do a check on the lookup (if exists), and if it does not exist, we insert it - preferably with a message to confirm - directly into the table ‘Container_number’ - and save the Workorder. Now the end-user needs to check, click the Looking Glass - Add, enter the number, Save, Select.. Quite a hassle. 

Let me know how this can be achieved the best/easiest way! 
Thanks! 

Blommetje 

Is the new container number an increasing number in order? If so, you can create a container_number "000 - placeholder”. When placeholder is selected the handler creates a container number for the new work order.  

Another option is to use a task instead of the form. You can then set a radio button: new container number/existing container number. Depending on the radio button you either show the field with the lookup or a field where you can enter a new number.  

Hi Erwin, 

No, container number (in this case) is just a random number/letter combination. Might toy around with the radio button, might be a solution. 

Thanks. 

Blommetje

Terms & ConditionsCookie settings