One to Many form. Display a memo based on column position in Many?

[GarryC]

Can someone help me out here.&nbsp;&nbsp;I am new to VFP and havn't tried this before.<br><br>I have a one to many form. My environment contains four tables<br>Table1=Case<br>Table2=Grading<br>Table3=User<br>Table4=Grading Type<br><br>Page1 displays an integer Case_id, Case_Desc, from table1.<br>Page2 contains a grid related by Case_id and displays across the page, User_ID from table3, and ten fields labled G1 to G10 that contain a numeric grading.<br><br>Table4, contains Case_id, Grade_id, and a Grade_desc Memo field. The Grade_id is an integer containing a value between 1 and 10.<br><br>I have placed the Grade_desc.memo field on page 1 and want to display its contents based on the column location of the cursor (1 to 10).<br>The columns will be non-moveable and by combining the current Case_id and ActiveColumn I will get the record position.<br><br>My question is how do I get the memo field to point to this position, and how do I refresh as I move across the colums?<br><br><br><br>

 

[JDurbin]

Do you understand 'Normalization' of data?&nbsp;&nbsp;I'm wondering if you data is normalized.&nbsp;&nbsp;Once you have that many things are much much easier <p>John Durbin<br><a href=mailto: john@johndurbin.com> john@johndurbin.com</a><br><a href=

http://www.johndurbin.com>

</a><br>ICQ #9466492<br>
ICQ VFP ActiveList #73897253

 

[GarryC]

My database is normalised.&nbsp;&nbsp;It was my brain that wasn't.&nbsp;&nbsp;I created a one to many form when I didn't need to.&nbsp;&nbsp;My relationships screwed up the grid.&nbsp;&nbsp;All I really needed to do was use the active column to locate the appropriate memo field and then refresh the display.