I have a very simple CMR form where users can chose from  a pull down list of users on the parent form. The idea is to have the embedded childform (containing 4 to 5 fields) dynamically update after a selection was made on the parent form. I am unable to find a code snippet or a clear example on how to do this.I'm a little confused as to why when a subform is added it does not prompt you for a parent or a one-to-many-relational key to the parent form.

 

In any event here is what I'm trying to associate from a parent to child form relationship

 

 

Parent Form "Player Registration"

 

Player_Name (Single, Unique, Parent Key)

 

Sub Form "Player History"

 

Player_Name (Child Key, Many Relational to the primary key)

Date_Started

Events_Participated

Dates_Participated

Reason

Reason_Code

 

- After selecting the name from the lookup pull down box, the app should refresh to show the last 10 entries made for that user.

- The same functionality or custom SQL query should also be available in the pivot report. Currently I am unable to craft an inner join for a report that will require said parent and child form (view) information.

 

Any detailed step to do this would be greatly appreciated.