Autogenerated FK columns

[andrew.mcgimpsey@amt-sybex.com]

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.

[ieva.n]

Hello,

We saw that you have created identical question in our support system. We will reply to the issue in the ticket you have created in support system.

Sincerely,
No Magic, Inc. Customer Support