Data Entry

Hello

I have 3 tables as follows:

tblCompany (lngCompanyNumberCnt[PK], strName)
tblSubject (lngSubjectNumberCnt[PK], strName)
tblLink (lngCompanyNumberCnt[FK], lngSubjectNumberCnt[FK])

I have an input form with tblCompany fields in the main
form and tblSubject fields in the subform.

To enter Subjects used at each Company, I select the
Company in the main form and then type the Subject Number
in the first field of the subform (which displays the
related Subject name).

I get the subject number from a paper-based report. The
report is many pages long as there are thousands of
subjects, so this procedure is very timely. Is there a non
paper-based way of doing this procedure (i.e. electronic)?

TIA
Martin

I get the subject number from a paper-based report. The
report is many pages long as there are thousands of
subjects, so this procedure is very timely. Is there a non
paper-based way of doing this procedure (i.e. electronic)?

Where do you get the "paper-based report" from? If it comes to you in an
electronic format then there is probably a way to incorporate it into your
database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Lynn

I just get the report from Access.

Martin

-----Original Message-----
I get the subject number from a paper-based report. The
report is many pages long as there are thousands of
subjects, so this procedure is very timely. Is there a
non
paper-based way of doing this procedure (i.e.
electronic)?

Where do you get the "paper-based report" from? If it
comes to you in an
electronic format then there is probably a way to
incorporate it into your
database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


.

Then create a combobox to select the information you want in the form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"placek" wrote in message
...
Lynn

I just get the report from Access.

Martin

-----Original Message-----
I get the subject number from a paper-based report. The
report is many pages long as there are thousands of
subjects, so this procedure is very timely. Is there a
non
paper-based way of doing this procedure (i.e.
electronic)?

Where do you get the "paper-based report" from? If it
comes to you in an
electronic format then there is probably a way to
incorporate it into your
database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


.

Thanks, Lynn. I shall give it a go.

-----Original Message-----
Then create a combobox to select the information you want
in the form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"placek" wrote in
message
...
Lynn

I just get the report from Access.

Martin

-----Original Message-----
I get the subject number from a paper-based report.
The
report is many pages long as there are thousands of
subjects, so this procedure is very timely. Is there
a
non
paper-based way of doing this procedure (i.e.
electronic)?

Where do you get the "paper-based report" from? If it
comes to you in an
electronic format then there is probably a way to
incorporate it into your
database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


.



.