You
need unique IDs for each bulb. You could simply use the numbers 1–12,
but the Database Wizard actually lets you choose records by picking
an ID. If you make IDs that hint at the actual bulb characteristics, picking is easier than simply looking at numbers.
In cell A2, enter this formula:
=LEFT(B2,2) &“-“& LEFT(C2,3)&“-“&D2
This takes the first two characters in columns B and C, adds a dash
between them, and finally appends the power to the end. So a 10-watt
compact fluorescent from Flair gets an id of Fl-CF-10.