I had a list say company that contains columns like CompanyName.

Then another list called as Addresses contains a lookup to conmpany and additional columns like Street, City

What i need to do is to create a another list where i will select the company address and some of the columns like Street, City of lookup tables is copied using say "Validation" into the columns of this list.

E.g. Address has Addr1, Street1, CIty1

when i select this address i want thes values are copies into the new list textboxes which can i overrride.

Is this possible and do you have any sample. I want to prefer the easiest way.

Any help is highly appreciated.

1 Answer 1


Create a seperate list to hold all cities and associated addresses. Then add a lookup column that points to the new list. You can configure the lookup column to do exactly what you need. Check here for an example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.