How can I relate a table in a subform to a selected record in a list?

[Klingest]

Hello people

I have a form with a list named "lstCases". This list shows the content of a specific table named "tblCases".

I want to make a subform in the main form which shows the content of another table named "tblCalculation", which is related to the table "tblCases" in a one to many relationship, so that you can have many calculations for each case.

What I really want is somthing like this: You select a record from the list, which shows the records of table "tblCases". For each record in "tblCases" another table from "tblCalculations" is associated/related. I want the related table to show up ind the subform, so that I can edit it and perform my calculations directly in this related table.

Another way to explain it: Normally when you select a table in access which is related to another table, you can get access to all the related tables by pressing the plus sign at the side of each record. Instead of pressing the plus sign, I want to select a record from a list in the main form, and let the related table show up in a sub form.

How can I do this?
If there is another way to do the above, I am also interested to hear about it.

Thank you.

 

[pbaldy]

I would expect to be able to set the master/child link properties of the subform control to the listbox and field name respectively.