Finding Results and Pasting Into Separate Field

[Guest]

Hello

I have Field 1 and Field 2. John Doe's name is shown in Field 1 of Record 1, Field 2 of Record 2, and Field 3 of Record 9. I need a field that will show that John Doe's name shows up in Records 1, 2, and 9. How do I get Access to gather this information and paste it into a separate field?

 

[Guest]

I forgot to add that I need to do this not only for John Doe, but also Mary Smith, Jane Jones, etc. -- in other words, multiple names. Then at the end I want to have a list of those names in alphabetical order with all the records that apply to each name.

 

[Cheryl Fischer]

Don't. Your brief description of your table indicates a very un-normalized
structure. Right now, you would have to add a field to your table to
contain the update you want to make; and that field will contain redundant
data for each name in the table. At this moment, you would have to update
three John Doe records. However, when John Doe's name appears in a 4th
record, you will then have to update 4 records; when you have 30 records for
John Doe, you will have to update 30 John Doe records.

I strongly recommend that you take a look at the following two links which
discuss normalization - the second link shows an example which bears some
resemblance to your current table.

http://databases.about.com/library/weekly/aa080501a.htm
and
http://databases.about.com/library/weekly/aa081901a.htm

In addition, here is an Amazon link to one of the better books on database
design: "Database Design for Mere Mortals", Hernandez
http://tinyurl.com/2uona

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Hello,

I have Field 1 and Field 2. John Doe's name is shown in Field 1 of Record

1, Field 2 of Record 2, and Field 3 of Record 9. I need a field that will
show that John Doe's name shows up in Records 1, 2, and 9. How do I get
Access to gather this information and paste it into a separate field?

 

[Guest]

Thanks very much for your response.