Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    23

    Unanswered: Best Method to Update Fields?

    Hi all,

    I've got an access database with two tables,

    a company table holding company info, Company ID, Name, Phone, Description etc

    and an Address table, address ID, Address 1,2,3, PostCode - the address table remains static but the company info can change on a regular basis, ie move address.

    Whats the best method to auto populate address fields in the company table from the address table? so its easily searchable using the existing built in search feature in access?

    thanks
    Last edited by Random Invert; 07-08-11 at 08:57.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You should never duplicate values among several tables. Use a Query joining both tables instead.
    Have a nice day!

  3. #3
    Join Date
    Apr 2011
    Posts
    23
    My original thinking was a subform with a pulldown to pre-populate the sb with the correct address which would make it easily changable if the company moves but that would mean having to build a search & results page based on the query covering both tables which I currently dont have time to do or the ability (but if thats the answer then i shall start researchng).

    Or is there a way to search the subform for a specific address and call up the related company without building an extra search and resluts screen?

    Am I right in thinking that the access built in search will only search the subform records relating the parent record thats selected?

    Thanks
    Last edited by Random Invert; 07-08-11 at 12:48. Reason: Had to re-write, sounded rude after reading it back

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •