Hi folks,
I am having an issue with generating the FK names through an ER to SQL transformation.
:: I have 2 entities: Customer and Address. I wish to use the Address as a billing address and delivery address so have set up 2 foreign key relationships.
:: I have named these relationships as BillingAddress and DeliveryAddress.
:: I have set the option ''Autogenerated FK column name template" to %r within the transform process as I understand that this will take the relationship role name as the name of the FK?
:: When the transform process finishes, the FK columns take the name of the table name, i.e. Address and Address1, not BillingAddress and DeliveryAddress.
Anyone have any ideas what I am doing wrong? Any and all replies welcome.
Thanks.