S
sd_eds
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
"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