Hi Wayne, I attempted a couple of times to run the queries etc and it
populates the companies but not the directors. I followed the instructions
you gave me but I must be missing something. Is there anyway that I could
send you what I have thus far so you can review and let me know what I have
been doing wrong. I can send it to you via email with the spreadsheet that I
am using. It would be nice to know what it is that I am doing wrong! LOL as
I created all the tables and labelled them what you suggested and then I ran
the 2 queries and 2 subqueries and then when I went to my form it was
blank...I feel like an idiot right now but it may be from fiddling around
with this for sometime now and I am just not seeing my mistake.