Table Updating Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

How do i create a form that updates ex. "Table1" witht the following fields:
ID, EmplName, WorkSite and DeductionAmount. I want the table to give me
automatically the name of an employee, his work site whenever i enter his ID
in ID field. And i will fill in hid deduction manually. There is another
table "EmployeeList" where i want the form to be linked to pull employees
info like his name, assigned work site. And at the same time updating the
"Table1" with the info.

Thanks and your help is highly appreciated.
alisher
 
alish said:
Hi All,

How do i create a form that updates ex. "Table1" witht the following
fields:
ID, EmplName, WorkSite and DeductionAmount. I want the table to give me
automatically the name of an employee, his work site whenever i enter his
ID
in ID field. And i will fill in hid deduction manually. There is another
table "EmployeeList" where i want the form to be linked to pull employees
info like his name, assigned work site. And at the same time updating the
"Table1" with the info.
Click to expand...

You shouldn't be storing the EmplName and WorkSite in more than one table.
The ID, of course should be stored in all tables that have information about
the employee. Here's a sample, given the information at hand of a suggested
setup if there may be several deductions for one employee:

EmployeeList:
Fields: ID, EmplName, WorkSite

Table1:
Fields: ID, DeductionAmount

Set ID to be the Primary Key (PK) in EmployeeList and a non-unique index in
Table1.
Set up a one-to-many relationship between EmployeeList and Table1

Create a main form using EmployeeList with a subform from Table1. Now you
can enter many deductions but only have to enter the employee ID, name, work
site once no matter how many deductions the employee has.

Tom Lake
 
It is not updating Table1. I created Mani form (with "EmployeeList") with
subform (Table1). When i enter ID it shows me name, work site, no problem
with that. but it is not showing in Table1. It is not updating it. The info
is not staing in Table1. I want it to update Table1.
 
Hi

I am not sure that I am understnding your problem correctly but if I am it
may be to do with child parent settings for the subform

Ray Brown
 
Back
Top