Hi John:

I have a question for you concerning my office search form I created last week. Everything works perfect, but I think I want to change the way I "reference" the combo boxes.

Let me explain:

The way I have it set up now, I am referencing names and not numbers. I believe I want to reference numbers, because it is better database design.

My p-view for my county combo box is currently:

WHERE counties.cjurisstate = ?THISFORM.CurrentState

&& When, the user selects FL in state combo box, any record in the county combo box that has FL in it, gets pulled. Which is great.

In addition, for my locality (city) combo box, my where statement for my p-view is:

WHERE locality_subordinate.cjurisstate = ?THISFORM.CurrentState AND ;
locality_subordinate.cjurisname_b = ?THISFORM.CurrentCounty

&& this works perfect as well. Anytime a user selects a county in the county combo, any record in the city combo with the same county gets pulled.

_____________________

My concern is when I get to my last combo box, which is actually pulling office titles.

I want to be able to reference id numbers and not text.

I have a field that is the link for everything. Each one of my views / p-views created for this office search form has it. The field is:

njurisid


My question is this:

How can I still use this number and have the text I want still show up in the combo boxes? I can't use the combo box builder, b/c I am using p-views. So, I need to use the property box.

Currently, for my states view, attached to my state combo box (combo box #1), I have placed in my row source:

states.cjurisstate, cjurisname

I have this set to:

Bound = 1

Can I change that to:

states.cjurisstate, cjurisname, njurisid

and hide the last field (njurisid), but still have that be used as the reference? I still want cjurisstate field placed into the text box, but I want the WHERE statement in my p-view to refer to the njurisid.


The same goes for the next combo box (county)

Currently, in the row source of that combo box, I have:

county_search_pview.cjurisname_b

I would like to have that changed to:

county_search_pview.cjurisname_b, njurisid

Can I do that and reference the njurisid, and still have the cjurisname_b placed into the combo box?

TIA for any commments

jason