Query builder

the main form has 3 lookup font fields that have the Class stored with in, the code generated does't show the last look up field , and I am struggling to get the class stored within

see pm for more details

There are no details in the PM. Please attach the page you are working on and any more details you can provide and I can see if I can help.

c ppm

The column references were wrong. If you use the Bindings panel it should give you the correct way to reference a column:

<?php echo($rsReport->getColumnVal("dbmFontW3Code")) ?>

sorry I an lost as what to do I would be grateful if you could give m some guidance
do I have to do the for alll th elookupfiles I want 2 get data from

I'm afraid I'm not entirely clear about your database structure or what exactly you are trying to do, so I can't really advise you on that. I can just look at the file and point out syntax errors.

If you want to do a premier support ticket on this then we can do screen sharing and I can take a look at your database and you can explain exactly what you are trying to do in context and I can help figure it all out.

see pm

The problem is that I don't understand your database structure, so I don't know how you would get the information out of the database you need. That is why a premier support ticket would be needed to discuss exactly what you are trying to do and analyze your database to understand how to do it.