Browse form joining 2 tables

[191brian]

Hi

I am new to nuBuilder and am excited about using it but am struggling with browse form with sql to join 2 tables I have tested the sql ok but the form does not display and records.

The form is to list a particular type of user joining the std user & access tables.

What am I doing wrong here?

Thanks in advance.

Brian ...

the sql is
SELECT zzzzsys_user.*, zzzzsys_access.* FROM zzzzsys_user JOIN zzzzsys_access ON zzzzsys_user.sus_zzzzsys_access_id = zzzzsys_access.zzzzsys_access_id WHERE ((zzzzsys_access.sal_code ="engineer"))

join form1.PNG

join form2.PNG

join form3.PNG

[admin]

191brian,

If you type nuCurrentProperties().browse_sql in the console, you will see how the records are filtered in the WHERE clause.

That might let you know why you are getting the results you are getting.

Steven

[191brian]

Hi Steven

Thanks for the info I found the spelling mistake in my sql using the nudebug results.

BTW how do you access the console you mentioned?

Brian ...

[toms]

Brian,

Press F12 to bring up the Developer Tools pane and then click the Console Tab.

[admin]

.