How do i have data from one table and form transfer automatically.

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

Guest

I have a table of equiptment, and each piece of equiptment must be inspected
yearly. I have a check box next to each piece of equiptment. If the item is
inspected, i want to be able to click the check box, have the inspection for
pop up (which already works), and i want to have the data from the equiptment
list transfer to the inspection form. (So i dont have to type all the
information in again).

If someone could please help me with this i would appreciate it.

matt
 
On Thu, 18 Aug 2005 12:59:16 -0700, PLEASE HELP MATT WITH ACCESS
PROBLEM <PLEASE HELP MATT WITH ACCESS
I have a table of equiptment, and each piece of equiptment must be inspected
yearly. I have a check box next to each piece of equiptment. If the item is
inspected, i want to be able to click the check box, have the inspection for
pop up (which already works), and i want to have the data from the equiptment
list transfer to the inspection form. (So i dont have to type all the
information in again).

If someone could please help me with this i would appreciate it.

matt
Click to expand...

A couple of concerns here.

Forms DO NOT CONTAIN DATA, any more than my office window "contains"
the Owyhee Mountain range. A Form is just a window, a tool to update
tables.

More seriously, it sounds like you want to copy the information
currently in the Equipment table into redundant fields in an
Inspection table. This is NOT necessary, prudent, or good design. The
equipment information should exist ONLY in the Equipment table; the
inspection table should contain a link to the equipment table, but NO
other information about the equipment itself.

I'd expect a design like:

Equipment
EquipmentID Primary Key
Description
<other information about the equipment itself as an entity>

Inspections
EquipmentID <foreign key link to Equipment>
InspectionDate <these two fields would be a joint Primary Key>
Results <or other fields about this inspection of this equipment>

No code and no popup form and no checkbox would be needed with this
design - simply use a Subform for Inspections, on the Equipment form.

John W. Vinson[MVP]
 
Back
Top