I'm teaching myself Database design, using MS Access (2007). This question may have a basic answer, but remember, I'm just a learner and it's not so obvious to me.
I would like to select a Company either by 'Name' or 'ID' or 'Account Number' in a Form and have all that Company's details such as Address and Phone Numbers change and appear too.
I have tried to do it in a Table using a Look-up list but only the company name changes .
Thanks in advance