"filo666" <filo***@discussions.microsoft.com> wrote in message
news:36880A2C-A54E-4651-A7D8-767F7D0D9C2B@microsoft.com...
> 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????

"PC Datasheet" wrote:

> 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 Datasheet
> Your Resource For Help With Access, Excel And Word Applications
>                               resou***@pcdatasheet.com
>                                  www.pcdatasheet.com
>
>
>
> "filo666" <filo***@discussions.microsoft.com> wrote in message
> news:36880A2C-A54E-4651-A7D8-767F7D0D9C2B@microsoft.com...
> > 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????
>
>
>

"filo666" <filo***@discussions.microsoft.com> wrote in message
news:408B6ACE-0825-4B8C-B30A-083BA18B8FD2@microsoft.com...
> Tank you very much, how can I be a member of PC Datasheet???
>
> "PC Datasheet" wrote:
>
> > 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 Datasheet
> > Your Resource For Help With Access, Excel And Word Applications
> >                               resou***@pcdatasheet.com
> >                                  www.pcdatasheet.com
> >
> >
> >
> > "filo666" <filo***@discussions.microsoft.com> wrote in message
> > news:36880A2C-A54E-4651-A7D8-767F7D0D9C2B@microsoft.com...
> > > 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????
> >
> >
> >

> What do you mean by "be a member of PC Datasheet"?
>
>
> "filo666" <filo***@discussions.microsoft.com> wrote in message
> news:408B6ACE-0825-4B8C-B30A-083BA18B8FD2@microsoft.com...
>
>>Tank you very much, how can I be a member of PC Datasheet???
>>
>>"PC Datasheet" wrote:
>>
>>
>>>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 Datasheet
>>>Your Resource For Help With Access, Excel And Word Applications
>>>                              resou***@pcdatasheet.com
>>>                                 www.pcdatasheet.com
>>>
>>>
>>>
>>>"filo666" <filo***@discussions.microsoft.com> wrote in message
>>>news:36880A2C-A54E-4651-A7D8-767F7D0D9C2B@microsoft.com...
>>>
>>>>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????
>>>
>>>
>>>
>
>