Cascading combo box

[Shakeel]

I am looking for some assistance please.



I enclose a copy of a very simple example of a problem I am having with cascading combo boxes.

I have site table that I am using for the source data for the site and sub site of facial injuries.On the patient form I have a injuries sub form and I wanted the cascading combo boxes to filter out the relevant items to the sub site when choosing the site.

Also I want to save the values entered into the relevant filed to be stored in the underlying injuries table. How do I do that?

Any advise please?

[davegri]

Why not just use one combobox to choose the proper row from the site table?

[Shakeel]

There are 7 subsites for mandible and several for others, I was trying to make it so less room for error in part data entry and simplicity on the form.
Does that make sense?

[davegri]

There are 7 subsites for mandible and several for others

So the user just selects one of the seven rows. Why is that not simpler than getting the same result from 2 comboboxes?

[Shakeel]

I get your point.
There is also an element of my learning how to do it, perhaps you can give me some advice on where I am going wrong?
Thanks

[davegri]

shak-davegri-v01.zip

See attached.
You have a Many-to-Many relationship requirement. The Injuries table is the junction table.
I renamed your Primary and Foreign keys to eliminate confusion, and removed duplicate field between tables.

[Shakeel]

Thanks very much Dave. I will review this for my learning as much as anything else. Very helpful

[davegri]

You're welcome. Good luck with the project.