Hello!
We currently use the "related records" field type in CMS to display a users listings right in their their user account section, which is great!
We use this coding in the MySql where clause
createdByUserNum='<?php echo mysql_escape(@$_REQUEST['num']) ?>'However, we have 46 different tables that this info is being pulled from which means we have 46 different fields. And usually a user only has listings in 1 or 2 of the tables, with the rest being blank. Is there a way to only display the related records field if there is information in it?
Say we have 26 related records fields, pulling information from tables named a, b, c, .....z.
User Joe has listings in tables a and b. But in his account all 26 fields show up, but only fields a and b have listings in there, leaving 24 empty fields that take up space.
Can we just display the fields that Joe has listings in, in this example, a and b.
Thank you for your help!
Jason Glass