Big trouble with little subforms!

[jabberwokiuk]

Hi guys,

I am fairly new to access - I think I undertand normalisation and relationships between tables.

I am trying to set up a simple pro-forma invoice database. I have three related tables:

tblInvoice -> tblCourse -> tblDelegates (all one to many with RI enforced CD)

I have created a mainform showing invoice details. On it are two subforms, the first shows the course details (price etc) and the second the delegates attending.

The problem I am having is that the second subform only displays the delegates for the first course listed. I thought that as the cursor moves from course to course the subordinate form would update to reflect the appropriate delegate list.

Do I need to roll up my sleeves and try learning VBA?

Forget being stuck for an hour - TWO DAYS (count em!) this is driving me crazy!

Can anyone help?

 

[neileg]

Sounds like the parent/child links are not working. Try removing the subform and then replace it ensuring that the subform button is clicked to invoke the subform wizard.

 

[jabberwokiuk]

Thanks Neilg

That worked, I just rebuilt the form from scratch. When I look at the child/master links they look the same between the old and new versions!?! But hey it works