Access populate field in table from another field in the same table

[sd_eds]

I have two fields, "Item" and "Informatio n" in the same table.
"Informatio n" contains three items from a seperate table created by a
lookup. I would like to substring out the first item and place it in
the "Item" field. Is there an easy way to do this? I would like the
"Item" field to populate after the contents of "Informatio n" have been
selected. Thanks in advance for any assistance.

Item Information
Item1 Item1 Item2 Item3

[Tom van Stiphout]

Re: Access populate field in table from another field in the same table

On Tue, 20 May 2008 13:40:45 -0700 (PDT), sd_eds <sd_eds@hotmail .com>
wrote:

With a combination of Left$ and InStr you can pick apart the
Information value and arrive at the Item value.

You are dangerously close to storing redundant information, a no-no in
proper relational database design.

-Tom.

>I have two fields, "Item" and "Informatio n" in the same table.
>"Information " contains three items from a seperate table created by a
>lookup. I would like to substring out the first item and place it in
>the "Item" field. Is there an easy way to do this? I would like the
>"Item" field to populate after the contents of "Informatio n" have been
>selected. Thanks in advance for any assistance.
>
>Item Information
>Item1 Item1 Item2 Item3