Addition

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

Guest

I have a form that has approximately 70 different fields on it. Each field
represents a particular upgrade for a model home. Each has a numeric value
in it, if the upgrade is available. My question is how can I make it so that
I can "check" just the items that I want as an upgrade and then have access
total just the upgrades that were chosen, and then generate a report based on
this iinformation.

Ray
 
Depends on how your data is stored.

If you stored it in a flat table like

house upgrade1 upgrade2 upgrade3
you will have difficulty to perform some practical queries
on it.

you could also had stored it like

Houseandupgradestable
houseid
upgradeid

Housetable
HouseId

Upgradetable
UpgradeId
UpgradeDescription

Please inform us some more on what your form is based.
 
Back
Top