Hi All I have a table (Products) with ItemID and want to add a field to this table that then is associated with another tables records. The extra field needs to be colour and each item could have up to 8 different colours asscocited with it.. can someone point me in the right direction for this? Thank you Andrew