How Update From Dropdown?

[Guest]

My form shows a field (CoverAuthor) from one table (Donors) which can be
changed only by selecting a field from another table (Authors.) What is the
best general strategy?

I really would like the form to show a dropdown that simply shows the
correct CoverAuthor for the current record but which will allow the user to
select a different one, which would then update the current record.

But, I'll take any approach that works.

Thanks in advance.

 

[Dirk Goldgar]

My form shows a field (CoverAuthor) from one table (Donors) which can
be changed only by selecting a field from another table (Authors.)
What is the best general strategy?

I really would like the form to show a dropdown that simply shows the
correct CoverAuthor for the current record but which will allow the
user to select a different one, which would then update the current
record.

But, I'll take any approach that works.

Thanks in advance.

I'm confused. What you've described sounds like the standard behavior
for a bound combo box. The combo box would be bound to CoverAuthor, but
would have the Authors table -- or a query of it -- as its RowSource.
Probably you'd set up the combo to show the author name, but store the
Author ID (or whatever is the primary key of the Authors table).

All of this is fairly standard, so I don't see where the problem lies.
Maybe I'm missing something.