Re: Criteria for multiple fields

Rather than having a row that stores the information about what vehicle it
is, when it came in and so on, pluse check boxes for "Throttle does not
work" and one for " Brakes are squealing" and a third for "Ashtray is full"
on the one row, you'd only store the information about the vehicle and visit
in the one table. You'd have a second table that would contain 3 rows. All
three would contain a field with the primary key value of the previous
table. Each of the 3 rows would contain the details of what was wrong.

For more details about database normalization, check out some of the
references Jeff Conrad has listed at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Hutch" <Hutch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2991EFB5-E5EC-4BD9-909C-D00DF9F24DAC@xxxxxxxxxxxxxxxx
> I'm not sure what you mean by creating seperate rows in a second table?
>
> "Douglas J. Steele" wrote:
>
>> You should really reconsider your design. What you've got are usually
>> referred to as "repeating fields", and one of the biggest problems is
>> that
>> the details of what the field means is stored in the field's name.
>>
>> You should insert a row into a second table corresponding to each
>> problem.
>> In other words, rather than having 10 out of the 30 checkboxes checked
>> for a
>> particular vehicle, you'd have 10 rows in a second table pointing to that
>> vehicle.
>>
>> One of the fields in the second table would be a description of what the
>> problem is.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "Hutch" <Hutch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:F703B632-10F3-490A-B587-84086A1F9885@xxxxxxxxxxxxxxxx
>> >I have a table that contains 30 check boxes in it. This table is only
>> >used
>> > when someone removes a vehicle for work. The boxes are used to note if
>> > there
>> > is a problem with the vehicle, i.e. Throttle does not work (Check Box).
>> >
>> > I need to create a query that would look for any field that has a box
>> > checked and show it. Is this possible with so many fields. I know the
>> > criteria field is limited to 10, is there another way I am missing?
>>
>>
>>


.

Relevant Pages

  • RE: Design Questions
    ... "Clifford Bass" wrote: ... tblVehicleHarnesses ... And the make combo boxes on change event might look like this: ... take several excel part number (by vehicle) listings and combining them into ...
    (microsoft.public.access.gettingstarted)
  • RE: Design Questions
    ... tblVehicleHarnesses ... And the make combo boxes on change event might look like this: ... take several excel part number (by vehicle) listings and combining them into ... Listing of part numbers for installation kits ...
    (microsoft.public.access.gettingstarted)
  • Re: Todays Metro
    ... |>> Which is one reason why advanced stop boxes without separate phasing ... Even if the advanced stop boxes are the recommended length, ... you need to pull in front of a vehicle that is stopped in a queue. ... and risk being run over by the lorry turning ...
    (uk.rec.cycling)
  • Re: check boxes
    ... I select my client from the drop down list, and then that specific client's vehicle reg details appear in the "VehicleReg" drop down list, where i choose a vehicle. ... This works well, but then if for example I would like to add new vehicle details for the selected client on the "jobs" form, I click on the "add vehicles" button which takes me to the vehicles for that specific client. ... For example, if you have 30 check boxes, then for every record ...
    (microsoft.public.access.forms)
  • Re: Just saw Cars on Blu-Ray... now *THIS* is what high-definition should look like!
    ... there's a larger capacity disc.>> ... certain number of baseballs. ... Let's say you have a vehicle that's ... storing boxes of baseballs. ...
    (alt.games.video.xbox)