Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with simple form
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Help with simple form
Miscellaneous
Thread ID:
00250260
Message ID:
00250260
Views:
48
I am in need of help creating a simple form. (This is all new for me, I need all the help I can get...)

Remote view 1:
rv_CaseType
id (PK)
description

Remote view2:
rv_NextKey
ID (PK)
TableName
NextKey

The form needs two text boxes, one for the CaseType ID, one for the description. In addition, I need to provide a listbox displaying just the CaseType description. The listbox description (highlighted) should be the same as the one displayed in the txtbox. (I know, it would be easier to use a drop-down combo box instead of the txtbox/listbox combo, but this is how *they* want it to work.) The form also has the wizbase button bar on the bottom, (to traverse/edit/add records.)
I've set the properties of the ID field (in rv_CaseType) to call my NextKey procedure, which creates an ID for the CaseType based on the next key value stored in the NextKey table. Therefore, I don't want the user to touch the ID field, (though I do need it displayed), only the description txtbox, listbox, and button bar.
My problem is in setting this up so that when I add a record, a new blank record is added that can be modified, (currently when I click add, the txt boxes go blank until they getfocus, then they display the values equal to the item that last had focus in the listbox). In addition, I need to know when/where I need to refresh/requery so that any changes to the table are reflected in both the listbox and txtboxes. Also, do both views need to be included in the data environment, or just the rv_CaseType?


Any info (however basic) will be greatly appreciated!
Thanks in advance,
Next
Reply
Map
View

Click here to load this message in the networking platform