Edward,

As always you were right on target. Thanks much!

Mandy

>>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.