auto flag checkbox fields via tresholds
Any suggestions for the following challange. I'm working on a change request application. It;s not unlikely that requests that meet certain criteria will need to be 'auto-approved' ie cost < $50 ...
Forum Discussion
Thank you, good to hear I'm doing good stuff here.
Please allow me to drill down a bit on the relationship and table locking.
Do I need to make a relationship the 'official way' and than make that single field in the CR-table containing '1' the connected field?.
In otherwords there is a hardcoded link this way to record ID#1 in the CR-treshold table.
Correct?
You see lock the CR-tresholds table before making the relationship.
Though can that lock be removed afterwards for modifiing tresholds.?
That lock is to avoid that QB will add fields or other stuff with the CR-thesholds table during making the relationship?
And what should the relationship be 1 CR -< many Threshold or 1 Treshold -< many CR's?
Thanks again
Please allow me to drill down a bit on the relationship and table locking.
Do I need to make a relationship the 'official way' and than make that single field in the CR-table containing '1' the connected field?.
In otherwords there is a hardcoded link this way to record ID#1 in the CR-treshold table.
Correct?
You see lock the CR-tresholds table before making the relationship.
Though can that lock be removed afterwards for modifiing tresholds.?
That lock is to avoid that QB will add fields or other stuff with the CR-thesholds table during making the relationship?
And what should the relationship be 1 CR -< many Threshold or 1 Treshold -< many CR's?
Thanks again