Thanks kerrance76! you have found that critical thing I was missing:)
I have kind of sussed out all those confusing 'source object', 'linked child fields' and 'link master fields' so my database is now working:) :)
The next thing I will do is document what I have learned and post my findings...
Hi, this is my first post in this forum and I am new to Access. I have a grasp of most of the basics though.
I am designing a telephone enquires database based on this template from Microsoft.
http://office.microsoft.com/en-gb/templates/TC010178391033.aspx?CategoryID=CT101426031033
I am...