Hi Mr. Pikman;

I had another question with regards to our conversation yesterday. I spent all last night trying to get my search form to work, referencing the id numbers and not the text, and was unsuccessful.

I just want to make sure I am on the right track.

I created 3 p-views to attach to my combo boxes.

To re-cap:

My 5 combo boxes are:

Country
State
County
Locality
Office

1. My first combo box, Country, just has a simple view that calls the country and id number

2. The next three combo boxes have p-views attached to them, and I just want to make sure I am referencing correctly.

my WHERE statement for my state combo box looks like this (this is my "state_search_pview")


WHERE state_subordinate.njurisid_a = ?THISFORM.CurrentCountry


OK, this is where I want to be sure I am ok:

I am saying here, THISFORM.CurrentCountry...... How does it know to look at the id number column in the rowsource of the country combo box, versus the text in the first column?

The row source of my country box is:

country.cjurisname, njurisid

I want to reference to be towards the second column, njurisid, not cjurisname.
That is what you were talking about yesterday, correct?

I made sure I had my country combo box set to BOUND = 2, AND BOUND TO = .T.

That should work, correct?

I am getting an error message that says, operator/operand type mismatch. Then, once my form pops up and I try to click on my combo boxes, it says, "field phrase not found"


Do you have any ideas what could be wrong?

I have a feeling my WHERE statements for my three p-views may be incorrect, so I could be jumping the gun with this message. Because, if those are wrong, I may have the rest set up correctly, and it wouldn't have a prayer of working.

I realize I am reaching a little here, because this message isn't too specific with code.

If you have any thoughts, I would appreciate hearing them

TIA

Jason