update one table from another table in refernce to another third table

[history]

Dear Friends,

I have 3 tables :

1-Emp
ID_Emp (Primary Key)
Sites_Comp
2-Dep
RefNo (Primary Key)
ToSite
3-EmpDep
ID_Emp
RefNo

I have a form contains Dep and sub form of EmpDep

This Form should contain RefNo and ToSite (Dep)
related to them numbers of employees listed in the subform (EmpDep)

After the form will be filled I want the field of (Sites_Comp) in Table Emp will be filled with data in the field of (ToSite) for each employee

How Can I update the (Emp Table) from (Dep Table)for each employee in (EmpDep) .

Thanks in advance,

waiting your reply

 

[history]

hey guys where are you ?? isn't anybody here !!!

 

[history]

Hello Friend,

Simply I have some persons sending them from place to place

and want to update the place (ToSite) where they will arrive in the main table (Sites_Comp) for each person
I mean the field (ToSite) would be the copied for all persons in the subform

 

[pbaldy]

FYI, I deleted your duplicate thread since this one got a reply (and I didn't understand the request either).

 

[history]

OK friends,

I have a manual format (filled by pen) to send people from one place to another
the form has a RefNo , date and the place that the people will go to.

what I need now to make this form automatic, grabbing the data from the main Table data and in the same time keeping the history of the transferring process in other table.

if it is clear, could you please give me your advice ?

 

[history]

OK

I have a main form for the employees, entering the data

I have another form for the sites, entering the data

I have another form for the transferring process :
1- data for the transferring RefNo, Request date and Site
2- sub form shows the list of employees and the date transferred

Thanks in advance

 

[history]

No the subform is free to select the employees I want

I mean I'm selecting each one by myself

 

[history]

I'm selecting each one ....

would you like to send the data base ?

 

[history]

The db would be no good to me, I'm on a mobile. In any event, teasing an explanation out of you will help you understand better.

Can you explain the selection process?

 

[history]

I couldn't understand what I should to do

 

[history]

Simply I'm selecting from the Sub Form the ID (from the ComboBox) then the rest of the fields will be filled automatically ...

 

[history]

what kind of "odds" !!!

don't you understand my issue ? OR don't you understand my words ?

anyhow, you are not capable to help, never mind and nice try

wish you the best