I have a layout based on a Donor table which has a field Entity for designating the type of donor (person or business). If Entity for a given record is Person, I need a few other fields (Employer and Occupation, for example) that are not needed when the donor is a business.

If I could show these extra person-related fields only when the entity is Person, that would make the layout less confusing. But how can I do this?

If there's a better way to approach this problem, I'd be open to that also. I tried to use the new tab panel but wasn't happy with the results because many of the fields are common to both person and business. And that seemed confusing.

Thanks!

Go to the database pros website

http://www.databasepros.com/resources.html

enter visibility into the find files, tips and articles and you will find at least one and I think more than one way of doing this, with example files.

This does it! thanks!