Make a column in the table made up of concat of two others

[Handford]

I have a table with primary key defined as a person's first and last name- so it only allows one instance of each persons name in the table. I was wondering if it is possible to make a column which is always the concatanation of this first and last name - hence make this a singular primary key instead of two?

The reason I want to do this is as it is having difficulty dealing with intersection tables with multiple primary keys.

Thanks

Handford

 

[lespaul]

I would suggest you pick a different PK. Either look through the table and see if there is another candidate or create an autonumber field. If you continue with your current approach you will discover more difficulties than you are currently having!


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design