DBLookupComboBox CONFUSION!

[lespaul]

Hello all - I have two tables - JurorMain and StatusCode
JurorMain has a field called StatusCD that equals the STCD field in the StatusCode Table. StatusCodeTable also has a field called STDESC (description). I would like to have the description for each juror's StatusCD show up in the combobox. Which is kinda happening. When I open the Individual Juror Form the correct description is highlighted IN THE LIST BUT DOES NOT DISPLAY IN THE BOX! How do I get the information to Display?

Also, when the drop down arrow is selected it only shows 2 rows of information and I'd like to have more showing. How do I increase the size of the box LENGTH (not width).

FYI - I am redoing this form because I was previously unaware of the DB functions. If I use this DBLookupComboBox component, will I still be able to automatically update the database with changes? I had this working properly with a joined SQL, but you can't use joins in the DB functions.

Thanks for any help!

Leslie

 

[svanels]

Check out How to use Database Look Up fields in the FAQ area of this forum or faq102-1212, in stead of ttable use tquery.

Regards Steven van Els
SAvanEls@cq-link.sr

 

[lespaul]

Thanks for responding Steven,

I have done exactly what the FAQ says to do (even before looking at it), but again the selection DOES NOT DISPLAY!! (I'm about to cry I'm so FRUSTRATED!!!)

I have a query to my main juror table with a dataset, I have a query to my statuscode table with a dataset. I have selected all the correct DataFields, ListSource, etc. The correct selection is highlighted in the list, but the display is blank!!

Any other help would be greatly appreciated.

thanks,

Leslie

 

[svanels]

Are your queries active? Steven van Els
SAvanEls@cq-link.sr

 

[lespaul]

Yes the queries are active. Everything works right except the display of the Status Description. All the DBedit boxes, DBRadioGroup buttons, and the DBText labels show the right information. The DBComboBox, if you select the arrow and scroll down (2 at a time since it won't show anymore than that!) has the description for that Juror's record highlighted, but not displayed.

I'm so confused!! Thanks for your help.

Leslie

 

[svanels]

Leslie try to do the thing first with ttables, i assume that your database is not to big yet. Another thing what is bothering you? dblookupcombobox or dbcombobox ? Steven van Els
SAvanEls@cq-link.sr

 

[lespaul]

I have tried both, but currently have a DBLookupComboBox on the form, but the DBComboBox didn't work either!

Thanks for your help.

Leslie

 

[svanels]

I rewrote the How to use Look Up fields with Tables /Queries faq102-1212

Maybe you have orphan records in your JurorMain Query. This means that your StatusCD doesn't have a matching STCD in the StatusCode table or query.
Tables are case sensitive and it would be good to make the STCD a key Field. Also referential constraints would be no luxury. I assume you are using paradox. Steven van Els
SAvanEls@cq-link.sr

 

[lespaul]

Actually we are using an AS400. The tables that are being used are new, and there are no orphans. The STCD is a key field and I am using referential constraints. I am developing this project from the ground up. These tables did not exist until just recently and I am a firm believer in relational databases, so they were designed that way. Thanks for all your help Steven, I appreciate it!

Leslie

I'll check out the FAQ.

 

[lespaul]

Steven,

I got this to work using a DBLookupListBox! Thanks for your help!

Leslie