Checkbox field on report as edit box field

[Jana]

Hello there. I''ve created a checkbox field of client names on my layout of single publications which they run ads in; meaning many clients for one pub. When I run a report by client to show the list of pubs for that particular client, the client name is defaulting to the first client name shown on the checkbox field rather than the name of the individual client I've found in my found records set; even though I've made sure to set up the field in my report as an edit box field.

Any suggestions how this can be corrected?

thanks!

[Ender]

Unfortunately, the structure you described does not work well for reporting.

You would have better luck with three related tables: a Client table, a Publication table, and a Client-Publication join table. With this structure, it's much easier to design a report of Publications by Client or Clients by Publication, based within the join table.