In ERwin I am getting the following error during the Validate SQL function.
1) Key Group:XPKME_XYZ_ABC -> Entity:ME_XYZ_ABC
Index member list is duplicated in another index on this table
[Entity:ME_XYZ_ABC] [Key Group:XPKME_XYZ_ABC]
2) Key Group:XIF1ME_XYZ_ABC -> Entity:ME_XYZ_ABC
FK Index member list is duplicated in another index on this table.
[Entity:ME_XYZ_ABC] [Key Group:XIF1ME_XYZ_ABC]
I think the error is because the FK is also the primary key and an idex is created for each.
How do I avoid this error? Or is it an error that is okay?
Thanks.