Hi David,
this information should not be stored in 3 yes/no fields ... what happens when more types of work are done? will you add more yes/no fields?
You should have a table for work types (or what you want to call it). You would have a foreign key in the Repairs table and might collect the information on a form with a combobox or option buttons.
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Thu, 9/1/11, djsdaddy531 wrote:
> Great Day, I have a form that has two
> subforms attached to it. In one of the subforms I have three
> YES/NO fields
>
> Original Estimate
> Work that was performed during the 'Repair Order'
> Work that was recommended after the 'Repair Order'
>
> I have upload a screenshot of the subform. You will see a
> label over the YES/NO fields whose backcolor is purple. What
> would be an 'eye-pleasing' way to identify these three
> fields. FYI, the labels simply say "How do I identify these
> fields."
>
> Thanks in advance for your assitance.
>
> r/David
>
>
Tidak ada komentar:
Posting Komentar