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 !!!

 

[Uncle Gizmo]

I can't grasp the essence of your question.

 

[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 ?

 

[Uncle Gizmo]

I'm still no wiser. I think you should frame your question in terms of your forms, not the tables. Something like my main form shows the employee detail, the subform shows the sites visited.

Or... The main form shows the site, and the subform shows a list of employees at the site....

 

[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

 

[Uncle Gizmo]

The subform on the transfer form, is this a list of all employees? Or is it filtered to show a subset?

 

[history]

No the subform is free to select the employees I want

I mean I'm selecting each one by myself

 

[Uncle Gizmo]

How do you identify each selection?

 

[history]

I'm selecting each one ....

would you like to send the data base ?

 

[Uncle Gizmo]

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]

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?

 

[Uncle Gizmo]

Ah! Excellent ... Can you show a pic with the items selected as well?

 

[history]

I couldn't understand what I should to do

 

[Uncle Gizmo]

No the subform is free to select the employees I want

I mean I'm selecting each one by myself

How do you perform this selection?

 

[history]

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

 

[Uncle Gizmo]

I don't think I can help you, we seem to be at odds. Goodbye.

 

[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