Names & numbers

[cdawley4]

I am modifying an existing database that contain names and phone numbers. I want to be able to select the persons name and let the database automatically select the phone number that matches that person. I am thinking that is going to be a relationship thing. Would there have to be any code involved or is it as simple as making a relationship?

Thanks,

Chris

 

[KenReay]

Hi

Relationships are about data integrity, not about getting data out.

What is the table structure?

Is it (approximately)

tblPeople
PersonName
PersonTelNo

Or

tblPeople
PersonId
PersonName

tblTelNos
PersonId
TelNoType
TelNo

If the former you could do it without code by using a two column combo box and a text box on a form

If the latter, then you would at least need a query



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[cdawley4]

The table is set up like:

tblPeople
PersonName
PersonTelNo

The main table includes the fields and I used a lookup wizard for it to look back at the tblPeople for the names.

PersonName
PersonTelNo

Thanks,

Chris