I have an access database with a table in it that contains two fields.
Incident ID and Parts
The Incident ID is like the IM... number below. the Parts field is like the {"PART1",...} below.
IM00001583957 {"PART 1", "PART 2", "PART 3", "PART 4"}

I need to make a table from the data above so that I have the same incident ID in each row but have each row contain only one part number like so:

IM00001583957 PART 1
IM00001583957 PART 2
IM00001583957 PART 3
IM00001583957 PART 4

The parts field could contain one or more elements in it. I need to create a row for each element in the parts field.

Any suggestions?