Auto-populate a field from a related field

[bpcstaff]

Simple question, but I can't seem to find an answer anywhere -

In a Contacts table, I have two fields:

1) First_name

2) Salutation

When I type "James" in the First_name field, I'd like "James" to autopopulate the Salutation field (where I could then modify it to "Jim", if need be).

I have a hunch I should do this through a lookup, and so I related a 2nd instance of the table to the first - but I can't get the Salutation to autocomplete - it prefers to stay blank.

Where have I gone wrong?

[Fitch]

No need for an extra relationship; use auto enter calculation instead of lookup.

[bpcstaff]

Thanks - and what function would I use in the auto calculation?

[bpcstaff]

Solved it - I didn't realize I could just enter the calculation as

[color:blue]First_name=Salutation

Edited June 25, 2008 by Guest