automatically enter information

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

Guest

I have 3 different tables that make up 3 different forms. What I want to be
able to do is enter information into these 3 different forms and have the
information automatically enter into the 4th form. I have to have a report
for each form and a final one with all the information in it. Is there a way
to do this? If it can be done how would I do this? Thanks in advance.
 
I don't understand your layout. What type of data is in each table? Why do
you have one form per table? Why not just have one form with three tabs on
it? Are these tables related one-to-one?

Why do you need a fourth form with everything? What does that all have to
do with your reports?

A form is used to enter, edit, and view data. The tables are used to store
data. Data can be stored in one or more tables depending on the data. A
report is used to pull data from one (or more) tables and pull it together
in a way that is good for printing.

You can probably do what you are asking with one form and one report. We'd
need to know exactly what is in your tables to be sure.

Post back some details and perhaps we can help you out.
 
The first table is
ANID# Analog Serial # Date Manufactured Tech Initial
Problems
The Second Table is
MAINID# Main Serial # Date Manufactured Tech Initial
Problems
The Third Table is
FPID# Main Serial # Analog Serial # Product Serial # Date Manufactured
Tech Inital Problems
The Fourth Table will have the same as the third plus a report of the
testing on each of the serial #'s and finds, comments etc. What my boss
wants for the fourth table is for the information of the Serial #'s to
automatically be put in the form. If there is a easier way please let me
know. I'm new to access and I'm working on this that someone else started.
He wants me to finish it. I'm not sure what is the best way to do this.
Thank you in advance.
 
I'm still not understanding why you have more than one table.

I'd probably do it this way:

tblDevices
DeviceID
DeviceType
SerialNumber
DateManufactured
Inactive (Y/N)

TblProblems
ProblemID
DeviceID
TechnicianInitials
ProblemDescription
DateResolved

TblTest
TestID
TestDate
TestPerformedBy
ProblemID
TestDescription
TestResults
Test Comments
etc.


If I am understanding you, you will have a bunch of devices. There will be
one record for each device stored in the devices table.

Each device could have one or more (or none) problems. Each of these
problems would have an entry in the Problems table. This is a classic
one-to-many relationship to the Devices table.

Each Problem will have one or more tests performed. Again, this is a
classic one-to-many relationship to the problems table.


As far as forms, you'd have a form to enter/modify/deactivate devices. This
form will be bound to the Devices table. You'd have a second form to enter
Problems. This form would allow you to select the Device# from a drop-down
list and enter the other Problem data. Personally, I'd display the device
type next to the device number, but it would not be editable on this form.
This data would be bound to the Problems table. A third form (or maybe a
subform on your problems form) would be bound to the Test table.

You could do a lot with subforms here. On your device form, you might have
a subform that displays all the problems associated with it. Or, maybe just
the unresolved problems?

Lots of options.

Note that I would probably not use tech initials, I'd have a fourth table
where I maintained my technicians. I'd assign each one a number. I'd also
store their name and include an Inactive checkbox. On your forms, you'd
enter the tech number. In your reports (or displays on your forms) you
could show their name or initials.

Your current layout/description sounds like you are trying to create a
spreadsheet, not a database. Access is a relational database, and the data
must be entered in a normalized method. If you want spreadsheets, use
Excel.
 
Thank you very much. I will try your suggestions. They make more sense.
Thanks again I appricate it. Have a good day. Thanks
 
Back
Top