Autopopulate AutoFill Form

[Guest]

Bump- Sorry, still need help with this issue. Thanks.

Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.

-------------
:

This question comes up frequently in the newsgroups and it stems from a
basic misunderstanding of how a database should be designed. In a properly
designed relational database, you only want to store information ONCE. So
if you have an Employee table (which based on Ofer's previous reply, I
assume you do), then you should NOT be storing the Sup, Manager, and Site
Manager again in the Form Info table. It is sufficient to store the
employee (preferably the EmployeeID number) in the Form Info table. This
will allow you to JOIN this table to the Employee table (on the employee) to
retrieve this other information for a query or report.

This is the reason I say you do not want to store this data again.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------


I'm sorry. I should have stated that I've added more fields to this form.
So this form has the combox with Employee name and when thats chosen it
populates Sup, Manager, and Site Manager. Under that I have Course Name,
Date
completed and a couple other fields. This Form is called "Form Info" and
is linked to a table named "Form Info table" so all info entered in the form
dumps to the table. Right now those fields that get autofilled are blank
inthe "Form Info table" but are filled in and look fine in the "Form Info
Form".
Hope this makes sense?
-----------

:
Actually, you do not want to store this data. Since it is already
stored in the Employee table, just Join your table to the Employee table in a
query when you need the information.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------

I just realized a problem. I have a table that the info on this form
dumps into. When using this autopopulate it works great on the form but's
doesn't dump the fields that auotofilled into my table.
Any ideas?

Thanks,
--------------

:
Your welcome, have a great weekend
\\// Live Long and Prosper \\//
BS"D
----------------

:
Thanks Ofer you really made my day. I've been working on this off and
on for about a week and couldn't get it to work. I tried something simular
but didn't work. This works perfect.
Thanks again.
------------------
:

In the RowSource of the combo, include all the fields from the table
that
you
want to display in the form

Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties

ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control
Source
property

Sup text box write
=[ComboName].Column(1)

Manager text box write
=[ComboName].Column(2)

[Site Manager] text box write
=[ComboName].Column(3)

===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes

--
\\// Live Long and Prosper \\//
BS"D
-----------------
:

This ones probably pretty easy but I cant get it to work. Ok I just created
a new DB. I have one table call "Employee" that has
Site Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd,
and Employee in the 4th column. I have a Form that has 4 lines Employee,
Sup, Manager, Site Manager. I want to use a drop down in the Employee field
and when you choose the Employee it looks back at the "Employee Table" and
Auto Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.

 

[Guest]

Make the three fields in the form bounded to the right fields in the table,
on the after update event of the combo, write the code
Me.Field1 = Me.ComboName.Column(1)
Me.Field2 = Me.ComboName.Column(2)
Me.Field3 = Me.ComboName.Column(3)

--
\\// Live Long and Prosper \\//
BS"D

Bump- Sorry, still need help with this issue. Thanks.

Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.

-------------
:

This question comes up frequently in the newsgroups and it stems from a
basic misunderstanding of how a database should be designed. In a properly
designed relational database, you only want to store information ONCE. So
if you have an Employee table (which based on Ofer's previous reply, I
assume you do), then you should NOT be storing the Sup, Manager, and Site
Manager again in the Form Info table. It is sufficient to store the
employee (preferably the EmployeeID number) in the Form Info table. This
will allow you to JOIN this table to the Employee table (on the employee) to
retrieve this other information for a query or report.

This is the reason I say you do not want to store this data again.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------


I'm sorry. I should have stated that I've added more fields to this form.
So this form has the combox with Employee name and when thats chosen it
populates Sup, Manager, and Site Manager. Under that I have Course Name,
Date
completed and a couple other fields. This Form is called "Form Info" and
is linked to a table named "Form Info table" so all info entered in the form
dumps to the table. Right now those fields that get autofilled are blank
inthe "Form Info table" but are filled in and look fine in the "Form Info
Form".
Hope this makes sense?
-----------

:
Actually, you do not want to store this data. Since it is already
stored in the Employee table, just Join your table to the Employee table in a
query when you need the information.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------

I just realized a problem. I have a table that the info on this form
dumps into. When using this autopopulate it works great on the form but's
doesn't dump the fields that auotofilled into my table.
Any ideas?

Thanks,
--------------

:
Your welcome, have a great weekend
\\// Live Long and Prosper \\//
BS"D
----------------

:
Thanks Ofer you really made my day. I've been working on this off and
on for about a week and couldn't get it to work. I tried something simular
but didn't work. This works perfect.
Thanks again.
------------------
:

In the RowSource of the combo, include all the fields from the table
that
you
want to display in the form

Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties

ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control
Source
property

Sup text box write
=[ComboName].Column(1)

Manager text box write
=[ComboName].Column(2)

[Site Manager] text box write
=[ComboName].Column(3)

===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes

--
\\// Live Long and Prosper \\//
BS"D
-----------------
:

This ones probably pretty easy but I cant get it to work. Ok I just created
a new DB. I have one table call "Employee" that has
Site Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd,
and Employee in the 4th column. I have a Form that has 4 lines Employee,
Sup, Manager, Site Manager. I want to use a drop down in the Employee field
and when you choose the Employee it looks back at the "Employee Table" and
Auto Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.

 

[Guest]

Hi Ofer,

That didn't seem to work or I did something wrong.
*Here's a pic of the DB I'm working on. might make things
easier?http://i24.photobucket.com/albums/c5/str82/DB.jpg

That idea you gave me before worked perfect it just isn't storing the fields
that get autofilled into the Form Info Table.

Thanks,

Make the three fields in the form bounded to the right fields in the table,
on the after update event of the combo, write the code
Me.Field1 = Me.ComboName.Column(1)
Me.Field2 = Me.ComboName.Column(2)
Me.Field3 = Me.ComboName.Column(3)

--
\\// Live Long and Prosper \\//
BS"D

Bump- Sorry, still need help with this issue. Thanks.

Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.

-------------
:

This question comes up frequently in the newsgroups and it stems from a
basic misunderstanding of how a database should be designed. In a properly
designed relational database, you only want to store information ONCE. So
if you have an Employee table (which based on Ofer's previous reply, I
assume you do), then you should NOT be storing the Sup, Manager, and Site
Manager again in the Form Info table. It is sufficient to store the
employee (preferably the EmployeeID number) in the Form Info table. This
will allow you to JOIN this table to the Employee table (on the employee) to
retrieve this other information for a query or report.

This is the reason I say you do not want to store this data again.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------


I'm sorry. I should have stated that I've added more fields to this form.
So this form has the combox with Employee name and when thats chosen it
populates Sup, Manager, and Site Manager. Under that I have Course Name,
Date
completed and a couple other fields. This Form is called "Form Info" and
is linked to a table named "Form Info table" so all info entered in the form
dumps to the table. Right now those fields that get autofilled are blank
inthe "Form Info table" but are filled in and look fine in the "Form Info
Form".
Hope this makes sense?
-----------

:
Actually, you do not want to store this data. Since it is already
stored in the Employee table, just Join your table to the Employee table in a
query when you need the information.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------

I just realized a problem. I have a table that the info on this form
dumps into. When using this autopopulate it works great on the form but's
doesn't dump the fields that auotofilled into my table.
Any ideas?

Thanks,
--------------

:
Your welcome, have a great weekend
\\// Live Long and Prosper \\//
BS"D
----------------

:
Thanks Ofer you really made my day. I've been working on this off and
on for about a week and couldn't get it to work. I tried something simular
but didn't work. This works perfect.
Thanks again.
------------------
:

In the RowSource of the combo, include all the fields from the table
that
you
want to display in the form

Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties

ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control
Source
property

Sup text box write
=[ComboName].Column(1)

Manager text box write
=[ComboName].Column(2)

[Site Manager] text box write
=[ComboName].Column(3)

===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes

--
\\// Live Long and Prosper \\//
BS"D
-----------------
:

This ones probably pretty easy but I cant get it to work. Ok I just created
a new DB. I have one table call "Employee" that has
Site Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd,
and Employee in the 4th column. I have a Form that has 4 lines Employee,
Sup, Manager, Site Manager. I want to use a drop down in the Employee field
and when you choose the Employee it looks back at the "Employee Table" and
Auto Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.

 

[Guest]

If you want to store this values in a table, you need to change the
RecordSource of the fields in the form to the name of the fields in the table.
And then after selecting a value from the combo assign the values to this
fields.

Me.Audience = Me.[Course name].Column(3)
etc with the rest of the fields

--
\\// Live Long and Prosper \\//
BS"D

Hi Ofer,

That didn't seem to work or I did something wrong.
*Here's a pic of the DB I'm working on. might make things
easier?http://i24.photobucket.com/albums/c5/str82/DB.jpg

That idea you gave me before worked perfect it just isn't storing the fields
that get autofilled into the Form Info Table.

Thanks,

Make the three fields in the form bounded to the right fields in the table,
on the after update event of the combo, write the code
Me.Field1 = Me.ComboName.Column(1)
Me.Field2 = Me.ComboName.Column(2)
Me.Field3 = Me.ComboName.Column(3)

--
\\// Live Long and Prosper \\//
BS"D

Bump- Sorry, still need help with this issue. Thanks.

Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.

-------------
:

This question comes up frequently in the newsgroups and it stems from a
basic misunderstanding of how a database should be designed. In a properly
designed relational database, you only want to store information ONCE. So
if you have an Employee table (which based on Ofer's previous reply, I
assume you do), then you should NOT be storing the Sup, Manager, and Site
Manager again in the Form Info table. It is sufficient to store the
employee (preferably the EmployeeID number) in the Form Info table. This
will allow you to JOIN this table to the Employee table (on the employee) to
retrieve this other information for a query or report.

This is the reason I say you do not want to store this data again.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------


I'm sorry. I should have stated that I've added more fields to this form.
So this form has the combox with Employee name and when thats chosen it
populates Sup, Manager, and Site Manager. Under that I have Course Name,
Date
completed and a couple other fields. This Form is called "Form Info" and
is linked to a table named "Form Info table" so all info entered in the form
dumps to the table. Right now those fields that get autofilled are blank
inthe "Form Info table" but are filled in and look fine in the "Form Info
Form".
Hope this makes sense?
-----------

:
Actually, you do not want to store this data. Since it is already
stored in the Employee table, just Join your table to the Employee table in a
query when you need the information.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------

I just realized a problem. I have a table that the info on this form
dumps into. When using this autopopulate it works great on the form but's
doesn't dump the fields that auotofilled into my table.
Any ideas?

Thanks,
--------------

:
Your welcome, have a great weekend
\\// Live Long and Prosper \\//
BS"D
----------------

:
Thanks Ofer you really made my day. I've been working on this off and
on for about a week and couldn't get it to work. I tried something simular
but didn't work. This works perfect.
Thanks again.
------------------
:

In the RowSource of the combo, include all the fields from the table
that
you
want to display in the form

Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties

ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control
Source
property

Sup text box write
=[ComboName].Column(1)

Manager text box write
=[ComboName].Column(2)

[Site Manager] text box write
=[ComboName].Column(3)

===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes

--
\\// Live Long and Prosper \\//
BS"D
-----------------
:

This ones probably pretty easy but I cant get it to work. Ok I just created
a new DB. I have one table call "Employee" that has
Site Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd,
and Employee in the 4th column. I have a Form that has 4 lines Employee,
Sup, Manager, Site Manager. I want to use a drop down in the Employee field
and when you choose the Employee it looks back at the "Employee Table" and
Auto Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.

 

[Guest]

i have a form with three taxt boxes

Name : Fname LName
First Name
Last Name

I want that when i lost focus from name Field First name & Last Name
automatically saprate and paste in to First Name & Last Name Field.

Can any One Halp Me?

 

[Guest]

Hey Ofer,

I seem to be getting more confused.
If I change the record source of the fields in the form to match the fields
in the table then the auto fill doesn't work.

I confused with this part too.
"And then after selecting a value from the combo assign the values to this
fields. Me.Audience = Me.[Course name].Column(3) etc with the rest of the
fields"

Thanks

If you want to store this values in a table, you need to change the
RecordSource of the fields in the form to the name of the fields in the table.
And then after selecting a value from the combo assign the values to this
fields.

Me.Audience = Me.[Course name].Column(3)
etc with the rest of the fields

--
\\// Live Long and Prosper \\//
BS"D

Hi Ofer,

That didn't seem to work or I did something wrong.
*Here's a pic of the DB I'm working on. might make things
easier?http://i24.photobucket.com/albums/c5/str82/DB.jpg

That idea you gave me before worked perfect it just isn't storing the fields
that get autofilled into the Form Info Table.

Thanks,

Make the three fields in the form bounded to the right fields in the table,
on the after update event of the combo, write the code
Me.Field1 = Me.ComboName.Column(1)
Me.Field2 = Me.ComboName.Column(2)
Me.Field3 = Me.ComboName.Column(3)

--
\\// Live Long and Prosper \\//
BS"D


:

Bump- Sorry, still need help with this issue. Thanks.

Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.

-------------
:

This question comes up frequently in the newsgroups and it stems from a
basic misunderstanding of how a database should be designed. In a properly
designed relational database, you only want to store information ONCE. So
if you have an Employee table (which based on Ofer's previous reply, I
assume you do), then you should NOT be storing the Sup, Manager, and Site
Manager again in the Form Info table. It is sufficient to store the
employee (preferably the EmployeeID number) in the Form Info table. This
will allow you to JOIN this table to the Employee table (on the employee) to
retrieve this other information for a query or report.

This is the reason I say you do not want to store this data again.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------


I'm sorry. I should have stated that I've added more fields to this form.
So this form has the combox with Employee name and when thats chosen it
populates Sup, Manager, and Site Manager. Under that I have Course Name,
Date
completed and a couple other fields. This Form is called "Form Info" and
is linked to a table named "Form Info table" so all info entered in the form
dumps to the table. Right now those fields that get autofilled are blank
inthe "Form Info table" but are filled in and look fine in the "Form Info
Form".
Hope this makes sense?
-----------

:
Actually, you do not want to store this data. Since it is already
stored in the Employee table, just Join your table to the Employee table in a
query when you need the information.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------

I just realized a problem. I have a table that the info on this form
dumps into. When using this autopopulate it works great on the form but's
doesn't dump the fields that auotofilled into my table.
Any ideas?

Thanks,
--------------

:
Your welcome, have a great weekend
\\// Live Long and Prosper \\//
BS"D
----------------

:
Thanks Ofer you really made my day. I've been working on this off and
on for about a week and couldn't get it to work. I tried something simular
but didn't work. This works perfect.
Thanks again.
------------------
:

In the RowSource of the combo, include all the fields from the table
that
you
want to display in the form

Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties

ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control
Source
property

Sup text box write
=[ComboName].Column(1)

Manager text box write
=[ComboName].Column(2)

[Site Manager] text box write
=[ComboName].Column(3)

===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes

--
\\// Live Long and Prosper \\//
BS"D
-----------------
:

This ones probably pretty easy but I cant get it to work. Ok I just created
a new DB. I have one table call "Employee" that has
Site Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd,
and Employee in the 4th column. I have a Form that has 4 lines Employee,
Sup, Manager, Site Manager. I want to use a drop down in the Employee field
and when you choose the Employee it looks back at the "Employee Table" and
Auto Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.

 

[Guest]

I think I got it figured out.
I used this-

Private Sub Employee_AfterUpdate()
Me.Supervisor = Me.Supervisor_Link
Me.POM = Me.POM_Link
Me.Site_Manager = Me.SiteManager_Link

End Sub

Thanks for all your help.

Hey Ofer,

I seem to be getting more confused.
If I change the record source of the fields in the form to match the fields
in the table then the auto fill doesn't work.

I confused with this part too.
"And then after selecting a value from the combo assign the values to this
fields. Me.Audience = Me.[Course name].Column(3) etc with the rest of the
fields"

Thanks

If you want to store this values in a table, you need to change the
RecordSource of the fields in the form to the name of the fields in the table.
And then after selecting a value from the combo assign the values to this
fields.

Me.Audience = Me.[Course name].Column(3)
etc with the rest of the fields

--
\\// Live Long and Prosper \\//
BS"D

Hi Ofer,

That didn't seem to work or I did something wrong.
*Here's a pic of the DB I'm working on. might make things
easier?http://i24.photobucket.com/albums/c5/str82/DB.jpg

That idea you gave me before worked perfect it just isn't storing the fields
that get autofilled into the Form Info Table.

Thanks,

:

Make the three fields in the form bounded to the right fields in the table,
on the after update event of the combo, write the code
Me.Field1 = Me.ComboName.Column(1)
Me.Field2 = Me.ComboName.Column(2)
Me.Field3 = Me.ComboName.Column(3)

--
\\// Live Long and Prosper \\//
BS"D


:

Bump- Sorry, still need help with this issue. Thanks.

Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.

-------------
:

This question comes up frequently in the newsgroups and it stems from a
basic misunderstanding of how a database should be designed. In a properly
designed relational database, you only want to store information ONCE. So
if you have an Employee table (which based on Ofer's previous reply, I
assume you do), then you should NOT be storing the Sup, Manager, and Site
Manager again in the Form Info table. It is sufficient to store the
employee (preferably the EmployeeID number) in the Form Info table. This
will allow you to JOIN this table to the Employee table (on the employee) to
retrieve this other information for a query or report.

This is the reason I say you do not want to store this data again.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------


I'm sorry. I should have stated that I've added more fields to this form.
So this form has the combox with Employee name and when thats chosen it
populates Sup, Manager, and Site Manager. Under that I have Course Name,
Date
completed and a couple other fields. This Form is called "Form Info" and
is linked to a table named "Form Info table" so all info entered in the form
dumps to the table. Right now those fields that get autofilled are blank
inthe "Form Info table" but are filled in and look fine in the "Form Info
Form".
Hope this makes sense?
-----------

:
Actually, you do not want to store this data. Since it is already
stored in the Employee table, just Join your table to the Employee table in a
query when you need the information.

Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
---------

I just realized a problem. I have a table that the info on this form
dumps into. When using this autopopulate it works great on the form but's
doesn't dump the fields that auotofilled into my table.
Any ideas?

Thanks,
--------------

:
Your welcome, have a great weekend
\\// Live Long and Prosper \\//
BS"D
----------------

:
Thanks Ofer you really made my day. I've been working on this off and
on for about a week and couldn't get it to work. I tried something simular
but didn't work. This works perfect.
Thanks again.
------------------
:

In the RowSource of the combo, include all the fields from the table
that
you
want to display in the form

Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties

ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control
Source
property

Sup text box write
=[ComboName].Column(1)

Manager text box write
=[ComboName].Column(2)

[Site Manager] text box write
=[ComboName].Column(3)

===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes

--
\\// Live Long and Prosper \\//
BS"D
-----------------
:

This ones probably pretty easy but I cant get it to work. Ok I just created
a new DB. I have one table call "Employee" that has
Site Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd,
and Employee in the 4th column. I have a Form that has 4 lines Employee,
Sup, Manager, Site Manager. I want to use a drop down in the Employee field
and when you choose the Employee it looks back at the "Employee Table" and
Auto Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.