Specify a column as both a foreign key *and* a primary key?

[cgwaters]

When using the Information Design Tool to create a data foundation, it's best practice to specify the primary key in each table; it's also recommended that the foreign key be specified.

In a data foundation that contains a hierarchy of tables--where a table is a child of a table, and that child table is a parent of another child table, etc.--how can a column be specified as being the foreign key (in relation to its parent) *and* a primary key (in relation to its child)?

Also, does the IDT provide a means to specify a key that has multiple columns?

[former_member182521]

Hi Chris,

Let us refer the designer guide here http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_info_design_tool_en.pdf

at section 9.6.1 Setting table keys

Regards,

Mani

[cgwaters]

I reviewed the IDT User Guide (especially section 9.6) but did not find the answer to my question.

[cgwaters]

I'm still unsure how to specify that a column is a foreign key (in relation to its parent) yet also a primary key (in relation to its child). Can someone help me understand how to do this?