I have a small database in Access 2002. In a new record I'd like to be able to type the name of the company and then have all the contact info appear. eg: I type IBM and IBM's street address, phone number etc, appear in the correct boxes. I have the tables set and the relationships set so is there a way to do this? I'd rather not use a drop down list or combo boxes. I just want to have appropriate fields populated and then be able to add new info. This came about because I've built several computers for the same company and I don't want to have type all the contact info over, but would like a seperate record for each computer even though they may be at the same address. Is this clear as mud? Larry Today seems like a good day to chew through the restraints.

You want to do this within the Table? Not possible. Why not create a Form with subforms? Life is more painless for those who are brainless.