In my table I would like some fields to contain more data,

Eg.


Product ID | Footprint
----------------------------
BC874 | RAD1
| RAD2
-----------------------------
Is that in any way possible

Create two tables and link them by ProductID

So...

Table1
[ProductID]
BC874

Table2
[ProductID], [FootPrint]
BC874, RAD1
BC874, RAD2

This is what's known as a 'one-to-many relationship'.

HTH