Master/Detail ID and NAME in one table, ID in the other

S

Steve-CPU

All,
I need some help. I have what would seem to be a simple issue but it
is driving me crazy. I have two tables:
1. Area: which has columns: Area_ID, Area_Name, Division_ID (FK)
2. Wells: which has columns: Well_Name, Well_ID, Number, Lat, Long, Area_ID
(FK to #1 above)

I have a simple form for Wells that has all of the Well columns including
the Area_ID in it and works fine. However, I want to show the user the
Area_Name in Well form instead of the Area_ID AND more importantly, I want to
be able to write the Area_ID back to the Well table when the user hits Submit.

Note that I do have the Well table as the master table and the Area table as
the Detail table related by the Area_ID.

I'm having trouble getting this to work properly. Does anyone have a simple
way to do this?

Thanks before hand.
 
Top