How could I call a data in a form

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

Guest

Hi, I have 2 tables: Table1 where I put the employee number with his name and
last name and table2 where I put the employee number ( with out name and last
name)and his debts, after that I made a Form with the Table 2, what I want to
do is when I put the employee name in the employee number place holder, I
want that automatically apears his name and lastname in an other place
holder, This is possibly to do with acces??? How????
 
I suggest you first change the design of your tables. Using the employee
number as a primary key will eventually bite you in the butt because it is
very susceptable to data entry error. I suggest you use EmployeeID as an
autonumber for the primary key in Table1 an EmployeeID as long integer for
the foreign key in Table2. After you do this, you need a form/subform. Base
the main form on Table1 and use a textbox to show the employee's name. Base
the subform on Table2. Once you have this set up, you will be able to use
the navigation buttons to go to the employee you wannt and the subform will
automatically display the debts of the selected employee.

You can then get more sophisticated in finding the employee in the main form
faster.
 
PC said:
What do you mean by "be a member of PC Datasheet"?




holder, I
Click to expand...
Hey you finally have somebody that wants to give you money :-)
Just tell him it's so much a month and give him your e-mail address.

gls858
 
Back
Top