Re: Using a table with a date field as a control date

You can do it with a before trigger and stored procedure. Regards David Reed >>> <jim.murphy@travelinsurance.ca> 26/05/2006 4:19 a.m. >>> am not sure If I can do this with a lookup, but what I would like to do is perhaps use lookup to retrieve a control date from an unassociated table to control what date is entered in another table. For example : the main table , table 1 has many entries with a field called date_ enter which is the date the record was entered. table 2 has a control_date If the date entered in table 1 is less than or = to the control date we want to give the user a error message. I am thinking of using display only field and lookup to set it Would need to have the date value from the control table available to the active table of table 1 when entering the the date_enter. However as there is no join field between the two tables am not sure how to do it. Was thinking might have to add a key field that was allways null and in the BEFORE EDITADD EDITUPDATE section set it so that the key would be null Am using Informix 5 , Any help would be appreciated _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Transit New Zealand - A transport system that builds a better New Zealand. This electronic mail message together with any attachments is privileged. If you are not the intended recipient: - Do not copy, disclose or use the contents in any way. - Please let us know by return e-mail immediately, then destroy this message. Transit New Zealand is not responsible for any changes made to this message and/or any attachments after sending by Transit New Zealand. Thank you.

David Coould you be a little more specific, or give a little more direction where to look. I am using Informix forms not 4GL Thanks, Jim