Transferring data from one field to another

[Guest]

I am creating a database to handle my duties as a section chief in the Air
Force, and I have one table for all the personnel I supervise and then
secondary tables for all their varied specific information. In one of those
tables I track each person's rater and multiple ratee's that person is
assigned. Each person can have only one rater but up to five ratee's.
In the main form is the ratee's general information and in the subform is
the performance report data including who that person's rater is. Once I
select a rater from a combo box of all eligible rater's, then I want Access
to take the name of the ratee that I just assigned a rater and list him as
the ratee under the rater's subform.

Thanks for all assistance

Dan

 

[Pieter Wijnen]

I might be off but:

Private sub Rater_afterupdate()
currentdb.execute "INSERT INTO RATERRATEES (RATER,RATEE) VALUES (" &
Me.Rater.Value & "," & Me.Ratee.Value & ")" ' if numeric
'currentdb.execute "INSERT INTO RATERRATEES (RATER,RATEE) VALUES ('" &
Me.Rater.Value & "','" & Me.Ratee.Value & "')" ' - if text fields
end sub

should do it

Pieter

 

[Smartin]

I am creating a database to handle my duties as a section chief in the Air
Force, and I have one table for all the personnel I supervise and then
secondary tables for all their varied specific information. In one of those
tables I track each person's rater and multiple ratee's that person is
assigned. Each person can have only one rater but up to five ratee's.
In the main form is the ratee's general information and in the subform is
the performance report data including who that person's rater is. Once I
select a rater from a combo box of all eligible rater's, then I want Access
to take the name of the ratee that I just assigned a rater and list him as
the ratee under the rater's subform.

Thanks for all assistance

Dan

Are you storing "multiple ratee's" as multiple columns on a person row?
And then you want to insert a ratee name in one of these columns on the
rater row to which the ratee is assigned? This is going to be difficult.
That's the bad news.

The good news is this would be much easier if you start with a
normalized data structure.

Let us know if I'm on track with your current design and objectives so
far and we'll go from there.