I have a module called Products. I've created a new module called Demos. This is for demo units we send to customers and a way to keep track of them. I'm trying to link this to Accounts. I'm using many-to-many. When I click save I get this answer:

Query Failed:ALTER TABLE products modify column id char(36) NOT NULL , modify column contact_id char(36) NULL , modify column manufacturer_id char(36) NULL , ADD INDEX idx_PRODUCT_name (name)::MySQL error 1061: Duplicate key name 'idx_PRODUCT_name'

Any thoughts on this?? I think the "error 1061..." is the problem but not sure how to track it. Does this mean I have 2 items called "product_name" in 2 different tables??

Thanks,
Tom