×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
Can someone help me out here.  I am new to VFP and havn't tried this before.

I have a one to many form. My environment contains four tables
Table1=Case
Table2=Grading
Table3=User
Table4=Grading Type

Page1 displays an integer Case_id, Case_Desc, from table1.
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.

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.

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).
The columns will be non-moveable and by combining the current Case_id and ActiveColumn I will get the record position.

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?



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

Do you understand 'Normalization' of data?  I'm wondering if you data is normalized.  Once you have that many things are much much easier

John Durbin
john@johndurbin.com

ICQ #9466492
ICQ VFP ActiveList #73897253

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close