Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Employee Records with Multiple Entries

Topic Labels: Base design
1004 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

In our airtable we have an employee tab and each employee can have multiple state licenses or memberships they belong to. Someone set up our employees to as duplicates for each state but the employee should be just one entry and the multiple licenses under that one entry. Can someone give some advice on the best way to accomplish this? Should it be a data entry field for each license? See attached.

2 Replies 2

Hi @Lindsay_Hier,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

Since you are a new member, there is no attachment to your post.

Your question depends on your requirements. What do you want to do with this data afterwards? You can put all the licenses in one Multi Select field if you want. That would be easy to do.


6 - Interface Innovator
6 - Interface Innovator

You could make the Licenses field a multi-select field and list the licenses as options. You then only need one employee in the table and can select the licenses they have in the Licenses field.

Is that what you’re trying to do?

Alternatively, you can create a Table with different types of Licenses. Link to that table from the Employees Licenses field, and then you can select the appropriate licenses per employee.