CODEWITHSUNDEEP
listsharepoint-2010
user900258
user900258

Reputation: 17

Relation between two list ? [SharePoint 2010]

Do you know how to do a relationship between two lists in SharePoint? I'd like to get an effect similar to the tables in the relation database. So having two lists: ListA and ListB, connect them after IDName relationship. I would like to add a ListA button opening ListB and I will be able to add the address of the person. I'm waiting for yours ideas, how to do this ? Sorry for my english.

Thanks, Lukasz

ListA:

**IDName** Name Telephone

ListB

IDAdress **IDName**  Street Country

Upvotes: 0

Views: 929

Answers (1)

Andrew Peacock
Andrew Peacock

Reputation: 771

Have you tried using a lookup column on ListA the points to a column in ListB?

If you want to show the full address in the lookup, you can create a calculated column in ListB to concatenate whatever columns you need and do the lookup on the calculated column.

I think this is the nearest you will get to a proper relationship.

Upvotes: 1

Related Questions