Data Entry

[placek]

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

 

[Lynn Trapp]

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.

 

[placek]

Lynn

I just get the report from Access.

Martin

-----Original Message----- 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 Trapp]

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

 

[placek]

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





.