Composite Key

[rathnam_qv]

Hi all,

i hv three common keys in three tables (like:ranjit,ram,murali)..then how to create cmoposite keys...can any one hepl me....urgent

Thanks in advance!!!

Smiley

[MK_QSL]

You can use in script like below......

FirstName&" "&MiddleName&" "&Last Name

[#3]

Hi Rathnam,

Composite key means combination of two or more fields will be used as a key.

For example,

Table A , Table B, consider the relation between the two tables are country, customer and salesperson.

You can create the key as country&'-'&Customer&'-'&Salesperson as KEY.

Sometimes you may need to add the date field also in the key based on the req as well as data modelling.

[#4 · Accepted solution]

hi

suppose you have three common field like A, B, C are common in Three tables.

then if you want to make composite key then in each table write this code

A & B & C as new_key

[preminqlik]

Create composite key in three tables

eg:

fieldName1&'separator'&fieldname2&'separator'&feildname3

for example

CusID&'-'&Location&'-'&Postion                     as               [Cus_Loc_Pos key]

here the separator is for developer understanding you can use any symbol in that.