Connecting Tech Pros Worldwide Forums | Help | Site Map

Query re memo field Access 2000

dulcie
Guest
 
Posts: n/a
#1: Nov 13 '05
>>When you say "list", I hear 1-to-many relationship. Should you not
have a
related table with a single record per paper rather than a text/memo
field
containing a textual list of papers?<<<

Thanks for your reply...Sorry google seemed not to let me reply to the
same thread - this might appear as a new heading.

Related tables are beyond me and anyone else in the office, since
no-one has come up with a solution to this so far. I was just hoping
there might be a simple solution to the search problem... if anyone
knows of one maybe they could let me know?

Thx,
Dulcie

Steve Jorgensen
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Query re memo field Access 2000


Related tables are what relational databases are all about, and they're not
that hard. Just pick up a beginning Access book of some kind at the book
store. The easy answer is to use the tool the way it works well, and the way
it's designed to work.

On 10 Jan 2005 08:23:02 -0800, pasirochma@hotmail.com (dulcie) wrote:
[color=blue][color=green][color=darkred]
>>>When you say "list", I hear 1-to-many relationship. Should you not[/color][/color]
>have a
>related table with a single record per paper rather than a text/memo
>field
>containing a textual list of papers?<<<
>
>Thanks for your reply...Sorry google seemed not to let me reply to the
>same thread - this might appear as a new heading.
>
>Related tables are beyond me and anyone else in the office, since
>no-one has come up with a solution to this so far. I was just hoping
>there might be a simple solution to the search problem... if anyone
>knows of one maybe they could let me know?
>
>Thx,
>Dulcie[/color]

Closed Thread