I don't see why a single need (like "Database Management") should need more than 255 characters. Could you explain?
If organisations have multiple needs and a need belongs to more than than one organisation, that's a classical example of a socalled n:n-relationship. And the solution that's as classical as the example is to break it down into 2 1:n-relations.
If you need more help than this basic theory, let me know in a reply.
Please bear with me as I explain what I'm doing in Access. I'm a newbie--have patience!
I am creating a database of nonprofit organizations in the community. One of the fields I'd like is "need identified," that is, a particular area in which that group needs help. The problem is that the 255 character field restriction is a hindrance.
Any suggestions? What I'd like is to create another table or list of those "Needs" to somehow link into this table, or choose from a drop-down list or something, so that the database is searchable by "Needs." For example, if my office finds we have resources in Database Management (ha...), it would be nice to search the database according to that to find the organziation that would most benefit. Ideas? Thanks,