display in form

[maw2be]

I have a form. I use couple dropdown, take data from tables. when I click on entry and open it I see proper information. but when I close (or before click on row) I see a numbers instead text. how to change it?

[admin]

I don't understand,

Can you post a picture?

Steven

[maw2be]

case type, hub and jurisdiction should be a text not numbers. when you entry form you get text.
how to change it?

nubuilder.jpg

[Richsurvey]

Hi maw2be,

Instead of the primary key in your SQL statement use the desired field name twice. e.g.:

If you originally had this: SELECT case_type_id, case_type_name FROM case_type

Change it to this:

Code: Select all

SELECT case_type_name, case_type_name FROM case_type

This works for me, but I'm not sure if this is the correct way this type of problem should be solved.

[maw2be]

Hi Richsurvey
no it's not working for me. I'm still see numbers (some primary key or what is that) in form field. Have to entry into it to see value. Will carry on to find solution.

EDIT: It's works, I simply have to try on new entry, delete old one.

[admin]

maw2be,

To Show Hub you will need to link the hub table you use in your dropdown, to your enquiry table (with INNER JOIN) and choose this field in the Browse instead of the Foreign Key in the enquiry table.

Steven

[rawia_tsalih]

Dear Richsurvey you're amazing my problem solved

[admin]

.