What happens when I click on row in a browse form?

[benritter]

Hello,
I've been searching the forums and wiki and haven't seen this topic, so here goes.
I have a browse form called "browse clients" that looks like this:

Screenshot 2020-09-16 153045.png

Some of the fields, like "notes" (a textarea) I would like to be able to click to expand, or at least open in a different iframe nearby.
Right now when I click on anything in any browse form, it does this:

Screenshot 2020-09-16 153827.png

how can I change what happens when I click on the row in a the browse form?
Thank you!

[Janusz]

https://wiki.nubuilder.cloud/ ... lectBrowse

[benritter]

Thanks Janusz,
I will try that. I've noticed a different problem on the same browse form. There is a subform "household" with a PK of 'client_id'. I have another browse in an iframe for the subform table. I have a column set to browse for "client_id" so my users can search for household members by the client_id. The problem is, all but the first client is showing an id of "0" in the subform browse. The client id's are all correct (auto increment) in the main browse form. here's a screenshot, with silly fake names.

Screenshot 2020-09-16 163632.png

In this screen shot, the column on the far left is the client id. you can see in the top form, there are id's 261, 262, 263. The household members for those clients are shown below but the id's are all "0" except for 261.

[gerese]

Hi , I think you should start with the manual.
https://sourceforge.net/projects/nubuilder/files/ nuBuilderForte_UserGuide.pdf , nuBuilderForte_UserGuide.sql .

No offence.

[Janusz]

difficult to answers when do not see the application and code behind
maybe try to look first on the mysql tables with phpmyadmin - do they look properly, is the PK really a unique PK.
is the SQL code in all Browse forms defined properly?
normally nuBuider displays what is in mysql tables - me personally did not experience not proper display of data.

[benritter]

Hi Janusz,
Yes the column client_id in the parent form is PK auto increment. And more importantly, I can see the client_id of rows 262 and 263 properly filled in phpmyadmin. But in the subform, the related rows stop at 261 and the rest have client_id of "0". just like in the browse form. In other words, the SELECT * seems to be executing correctly. but the FK/PK relationship is not.
What code or screen shots would it help for you to see?

[Janusz]

Hi,
Maybe try to login to the Discord chat which Kev1n created:
https://discord.gg/QHJ27A
and it would be easier to discuss it there