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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sd_eds - 20 May 2008 21:40 GMT

I have two fields, "Item" and "Information" 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 "Information" have been
selected. Thanks in advance for any assistance.

Item Information
Item1 Item1 Item2 Item3

Reply to this Message

Tom van Stiphout - 22 May 2008 02:56 GMT

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 "Information" in the same table.
>"Information" contains three items from a seperate table created by a
[quoted text clipped - 5 lines]
>Item Information
>Item1 Item1 Item2 Item3

Reply to this Message