Multidropdown Tagging System

I’m trying to create a tagging system but I’m kinda lost right now. What I want to do is to Tag an agent based on the following Commission Programs and vice versa.

Example:

Commissions can have multiple agents:

Commission 1 = Agent 1, Agent 2, Agent 3
Commission 2 = Agent 1, Agent 4
Commission 3 = Agent 2

Agents can have multiple Commissions:

Agent 1 = Commission 1, Commission 2
Agent 2 = Commission 3
Agent 3 = Commission 1
Agent 4 = Commission 2

both table must be connected.

Here is my database structure (not sure if this is correct)

Data Types:

Fields:
image
image
image

Under commission program table, I can tag each agent

image

But I’m having a hard time tagging each agent based on the commission program table

This should be:
Agent 1 = Com1, Com2
Agent 2 = Com2

The way you bulit it, your tables are not connected.

The Agent Datatype should have a field called “Tags” and the type should NOT be “List of texts”. But “List of Tags”

The Tag Datatype should have a field called “Agents” and the type should NOT be “List of texts”. But “List of Agents”

Dropdown is now empty

image

Multidropdown:

Can you now share how is your database?
And what type of constraint and workflows you did in this page?

This topic was automatically closed after 70 days. New replies are no longer allowed.