Is it possible to create a relationship between a text box and a key?

[oatsybob]

I'm still a bit new to access and I really appreciate the responses I've received from this forum so far. I do still have a few issues I'm trying to work through and I've hit a bit of a roadblock. Basically, a component of my database is to track the various partnerships and specific interactions the non-profit for which I work has had with other organizations and the community. The problem is that for one of my data points I need a fairly lengthy, narrative-style description for each interaction. I've tried to break the interaction down into manageable formalized categories--date of last contact, type of contact, amount donated, etc, but what I really need is a text box or some sort of input that allows a long description but that is still related to my primary key. Is this possible? Also, I apologize my question is too vague, confusing, and context-less to be understood. I can't tell.

[Rod]

Use a Memo data type in the table design. Read up on data types.

[orange]

A few points that may assist:

There is an existing free data model for Non-profit orgs at
http://www.databaseanswers.org/data_...fits/index.htm

It may be overkill for your specific needs, but should help you with tables and relationships.

Here is a great article on database principles
http://forums.aspfree.com/attachment...2&d=1201055452

[oatsybob]

Oh duh! Haha thanks, that is exactly what I needed. Also thanks for the link to the non-profit database design. Mine's fairly similar so that's reassuring.