Insert new row into detail/lookup through form field

Question

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

Erwin Ekkel · Accepted Answer

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.

Blommetje · Answer

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

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded