It's days that I am facing this problem, and hope someone can show some light on this. I am a newbie to Zoho Creator.

I am trying to create a Job Card application through Zoho Creator so I have created so far a form named "Suppliers" where I can store all the details of the suppliers of machines we sell, in this form I have also created a subform called "Systems"where I store the different machines model name.

Then I have created another form called "Machines" where I have implemented 2 lookups:

One to the records contained in Suppliers

One to the records contained in Systems

I have set up a filter on the Systems Lookup field that sorts all the different machine model names based on the Supplier that the user chooses.

In this Machines form I have added a single line field to insert manually the serial number of the machine to be entered.

Now the problem:

I need to create another form called "Machines Sold" where I can add the date of sale and Installation of the machine and assign it to a customer.

The problem is that when I create a lookup to "Machines" it only enables me to choose which machine based on the Serial Number Field. Instead I would like the lookup field to show Supplier Name - Machine Model - Serial Number in the Dropdown.

Is there a way to achieve this result?

When I create the lookup field in the Machines Sold form, selecting the Machines form, the only fields showing are Serial Number and Date of Arrival. The other 2 lookup fields Suppliers and Systems are not showing.

Thanks for any help