Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data environments and grids
Message
From
11/08/1997 16:00:38
 
 
To
11/08/1997 15:27:44
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00044082
Message ID:
00044086
Views:
26
>Hi all,
>
>Here's my latest round of questions ;^).
>
>1) In my Data Environment (DE), cursor1 is my Agency table with an Alias of agency. Occasionally I'm getting an error message 'Alias Agency doesn't exist' when run the form. I've checked all my methods and I don't even see anything referencing an agency alias. Your thoughts?
>
>2) I've been reading your recommendations to *not* include relations in the form DEs, but instead use LinkMaster and ChildOrder or something like that. I've heard of them, but would love more details (as always, where do you put everything ;^)!) since I've got a number of relations in my DE's currently.
>
>3) Finally, I've got a grid in my form in which I'd like a dropdown list for one of the columns. What I want to display is a person's title for each person when the grid first comes up (which comes from the displayvalue based a relation between the person's 'title id' and my codes table that contains the display values that correspond to the unique i.d.s in the data tables).
>
>When a user clicks on a specific person's title, I'd like a dropdown list to display the available titles (the display values) so the user can change the title if necessary. I've seen samples of this, but can't seem to get it to work in my form. Now I get blanks in the Title column until you click on a person's title field. Then my entire code/i.d. table becomes the dropdown list with the cursor at the correct display value... ooo, so close.
>
>Any ideas, including where do I filter my display table so that only codes with "title" in the codetype show up in the dropdown list??? I know this isn't rocket science, but I can't find good help in the manuals (gee, go figure!).
>
>MTIA ... as always :^)
>
>Mandy

1. It might be that you programmatically open some other table/cursor in the same work area.
2. Personally, i use cursors, but LinkMaster/ChildOrders stuff is very good and straightforward, look at it in on-line help, please.
3. I guess, you forgot to set Grid.Column.Sparse=.F. Your combobox should have RowSource and I would advise to use cursor which will be filled in Combo.Init event using Select-SQL with appropriate Where clause 'to filter' table value list.
3.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform