J
Jaime Gutierrez
I am developing a hardware repair tracking database in Access 2002.
Each piece of hardware is in the Asset table and is identified by an
AssetID. I have a table called tblMaintTicket that holds general
repair info about each individual repair session. Each asset can have
more than one Maintenance Ticket.
There were two tables that had a many-to-many relationship with
MaintTicket. tblMalfunction contains the different problems that can
strike each asset. Each MaintTicket may involve more than one
malfunction.
tblTest contains the different types of tests that can be performed
during a MaintTicket session in order to fix the problem(s). More
than one test may be performed during each MaintTicket.
I established linking tables in order to resolve the many-to-many
relationships (tblMaintTicket > tblMaintTest > tblTest; tblMaintTicket
indicates whether or not a malfunction is present or a test has been
performed on a particular MaintTicket.
I am tempted to throw all of these choices into the MaintTicket table
and slap them onto the MaintTicket form with checkboxes next to them
and get it over with. Nevertheless, I want to be able to modify these
options without having to redesign the form down the road. How do I
put all of this information on the MaintTicket form without hardcoding
it, and how do I save all of this info in the appropriate database
location?
Any suggestions will be appreciated. Thanks for your time.
Each piece of hardware is in the Asset table and is identified by an
AssetID. I have a table called tblMaintTicket that holds general
repair info about each individual repair session. Each asset can have
more than one Maintenance Ticket.
There were two tables that had a many-to-many relationship with
MaintTicket. tblMalfunction contains the different problems that can
strike each asset. Each MaintTicket may involve more than one
malfunction.
tblTest contains the different types of tests that can be performed
during a MaintTicket session in order to fix the problem(s). More
than one test may be performed during each MaintTicket.
I established linking tables in order to resolve the many-to-many
relationships (tblMaintTicket > tblMaintTest > tblTest; tblMaintTicket
concatenated primary key, the linking tables have a yes/no field whichtblMaintMalfunction > tblMalfunction). In addition to a
indicates whether or not a malfunction is present or a test has been
performed on a particular MaintTicket.
I am tempted to throw all of these choices into the MaintTicket table
and slap them onto the MaintTicket form with checkboxes next to them
and get it over with. Nevertheless, I want to be able to modify these
options without having to redesign the form down the road. How do I
put all of this information on the MaintTicket form without hardcoding
it, and how do I save all of this info in the appropriate database
location?
Any suggestions will be appreciated. Thanks for your time.