B
bicyclops
For a given part number (Part# table) there may be one or more Defect Records
(Defects table). On a form with the list of part numbers, a field will
highlight if at least one Defect record exists. This form needs to have some
controls that are editable.
In the query for the form, I referenced another query that will return a
value if at least one defect exists for the part number. Works great, but
using that method makes my main query un-editable.
The other method is to use a domain aggregate function on my form to
reference the Defect query, but this makes the form very sluggish.
Any other ideas how to do it?
Thanks!
(Defects table). On a form with the list of part numbers, a field will
highlight if at least one Defect record exists. This form needs to have some
controls that are editable.
In the query for the form, I referenced another query that will return a
value if at least one defect exists for the part number. Works great, but
using that method makes my main query un-editable.
The other method is to use a domain aggregate function on my form to
reference the Defect query, but this makes the form very sluggish.
Any other ideas how to do it?
Thanks!