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?
Last edited by Random Invert; 07-08-11 at 12:48.
Reason: Had to re-write, sounded rude after reading it back