
Need urgent help with optional fields
On the properties for the field on the update window, go uncheck the required
attribute. This should allow it to be blank or zero. Also, on the ACTIONS
tab for the control, make sure you don't have it trying to do a lookup when
the control is selected, only do the lookup when it is selected.
Kelly Orr
http://www.goldtechservices.com
Quote:
> Have failure table that has 2 fields named primaryid and secondaryid which
> are keys to another table called Codes.
> During inserting a new record. Entries in these fields have to be selected
> before the whole record (which include other fields in the failure table)
> can be saved. How can I set these to be optional -so user does not have to
> set the fields if he doesn't want to.
> Using C5.5G with MSSQL7 with the 2 fields set in mssql 7 as "allow nulls".
> Have relationship in dct for these 2 fields as restrict(server).
> Thanks