Is there a way that an input can be provided for a lookup-type custom field. More specifically, can the input be a value that is associated with a static field for the current record. For instance, if I create a new table in the OnTime DB that has a 'defect ID' column to relate each record to a specific defect, can I then get access to that record when it is loaded in order to pass the defect ID value to a stored procedure that populates a lookup on the form in which that defect is opened?

 If not, that would be a great feature to expand the capablities of using stored procedures for lookups.