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

history

Egyptian Pharaoh
Local time
, 01:58
Joined
Jan 26, 2008
Messages
190
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
 
hey guys where are you ?? isn't anybody here !!!
 
I can't grasp the essence of your question.
 
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
 
FYI, I deleted your duplicate thread since this one got a reply (and I didn't understand the request either).
 
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 ?
 
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....
 
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
 
The subform on the transfer form, is this a list of all employees? Or is it filtered to show a subset?
 
No the subform is free to select the employees I want

I mean I'm selecting each one by myself
 
I'm selecting each one ....

would you like to send the data base ?
 
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?
 
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?
 

Attachments

  • 676767.jpg
    676767.jpg
    88.2 KB · Views: 79
Ah! Excellent ... Can you show a pic with the items selected as well?
 
Simply I'm selecting from the Sub Form the ID (from the ComboBox) then the rest of the fields will be filled automatically ...
 
I don't think I can help you, we seem to be at odds. Goodbye.
 
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
 

Users who are viewing this thread

Back
Top Bottom