Auto fill trouble

[Jim]

I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific letter. If I edit the
description for one record, it edits the same for all records in which
I've applied the same autofill (auto lookup). I'm set up where the
letters come from a lookup combo box (limit to list "Yes") and the
record source for the form is a select query with two tables using a
one-to-many relationship. The relationship goes from the first table's
field where the letter is entered to the second table's field with the
same letters and a second corresponding field with a description for
each letter.

My desire is to autofill (auto lookup) the second field of a record and
to be able to edit (add or delete information) in that record's field
without altering the original description in the "many" table.

Please let me know if there are any solutions to this small but
debilitating problem.

Thanks

Jim

[purpleflash]

Hi Jim

If I understand your question right then a possible solution would be
to handle the two fields as separate entries to your table. So your
underlying table has Field "ABC" and field "Description" in it with
only "ABC" limited to the list!

Make "ABC" a combo box with two columns based on your constraining
table ("A", Description Text") then using the OnClick event on the
combo box populate the "Description" field with the data held in the
second column (Me!Description = Me!ABC.column(1) I think, remember
column numbering starts at 0 not 1!) this should populate the
Description field with the data associated with "A","B","C" etc but
since the data in the "Description" field is not constrained you can do
whatever you wish with the text in it!

Purpleflash

Jim wrote:

I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific letter. If I edit the
description for one record, it edits the same for all records in which
I've applied the same autofill (auto lookup). I'm set up where the
letters come from a lookup combo box (limit to list "Yes") and the
record source for the form is a select query with two tables using a
one-to-many relationship. The relationship goes from the first table's
field where the letter is entered to the second table's field with the
same letters and a second corresponding field with a description for
each letter.

My desire is to autofill (auto lookup) the second field of a record and
to be able to edit (add or delete information) in that record's field
without altering the original description in the "many" table.

Please let me know if there are any solutions to this small but
debilitating problem.

Thanks

Jim