Entity Manager (Create lookup field list)

[wusy8lqf]

Good day everyone, I hope someone can help.

I want to create two very simple tables, the first one will hold contact/company type (so, values being supplier/partner/client). The second table, will hold service names (values being, backups/storage/programming/web) and so on.

Those tables then are to be reference from the "Accounts" and maybe "Contact" layout (assuming relationship many (contacts/accounts) to one)

For a quick test, I created a new field within the contact layout using an "Multi-Enum" format, and that looks great, but I am unsure how to create a whole new "external" table as a lookup (like how MS Access works)

Many thanks for any pointers

[rinorway]

https://docs.espocrm.com/administration/entity-manager/

Use "link multiple field" and add that field to your layout

[wusy8lqf]

That's brilliant, thankyou rinorway.

Can you tell me, from what I understand, I need to use the "Base" template, add my own field to use, and ignore the other unused fields on that new entity?