also new in cr, how do i list fields

[calvi]

How do I show list of names from the namefield with the prerequisite of another field(called "city&quot in the same table that city must be e.g. "New York"

with sql is: select names from table where city = "New York"

how do i write this in crystal syntax?

 

[lbass]

You could do a record select:

{table.city} = "New York"

and then add {table.name} to your details section. Or, you could create a formula and use this as a detail field within your report:

if {table.city} = "New York" then {table.name}

-LB