Linking tables in Maintenance Contract

[Guest]

I Have a problem and I hope someone can help.

I allready have a program that has this function & table structor and
function working well.

Customers > Customers Sites > Maintenance Contract > Maintenance equipment

I want to change how it works adding in an extra table.

What I have done is added "Site Equipment" table so we can add all the
equipment customer has on site and working well. We currently retype the
site equipment into maintenance equipment table (Same equipment the site has)
but what I would like is to select from a combo box list in a form relaiting
to customers site / site equipment. Can this be done? The tables we have are
this.

Table = "clients" - key Field = "clientno"
Table = "sites" - key Field = "SiteNo"
Table = "MaintContract" - key field = "MaintContractNo"
Table = "MaintEquip" - key field = "MaintEquipNo"
Table = "SiteEquip" - key field = "EquipNo"

In the combo box when we add the equipment to the maintenance contract we
would like to select the "Equipment Number" from the "SiteEquip" table.

Other field we would like to display on a form and in a report from the
"SiteEquip" Table but relate only to the Maint Contract are "Location", "Area
Served" & "Manufacture". What Feilds do we need to create in "MaintEquip" to
make all this work and any other information we need like code or Querys. If
you can work this out you are a champion!!!!

 

[Tim Ferguson]

Customers > Customers Sites > Maintenance Contract > Maintenance
equipment

What I have done is added "Site Equipment" table so we can add all the
equipment customer has on site and working well.

What is the difference (or relationship between) between
MaintenanceEquipment and SiteEquipment? You already know what
MaitenanceEpipments are kept in which CustomerSite, by a join through the
MaintenanceContract table. Is this about equipment that is not covered by
a contract?

We currently retype
the site equipment into maintenance equipment table

That sounds bad -- major Design Problem flag!

In the combo box when we add the equipment to the maintenance contract
we would like to select the "Equipment Number" from the "SiteEquip"
table.

Can't really help with the GUI until we have the semantics nailed down
and correct tables design.

B Wishes


Tim F