bohammonds
IS-IT--Management
This is my problem... I am developing a application for my office. I need to be able to display calculated date information on a form and possibly a report.
Scenario: Legal cases are received into an department by a clerk and must be date received. The case is also given an action code which determines the number of days due out.
Example: Date_In: 03/08/2002
Action_Type: Case Review
Days_Out: 7
Action_Type and Days_Out fields are located in a database named "Action". Date_In is a field in the main database named "Cases".
On my form I can select the "Action_Type" from a combo box and update the linked field in the "Cases" database. However, I am not able to retrieve the assocated "Days_Out" value for calculation.
In the above example I would like to display the result: 03/15/2002
Scenario: Legal cases are received into an department by a clerk and must be date received. The case is also given an action code which determines the number of days due out.
Example: Date_In: 03/08/2002
Action_Type: Case Review
Days_Out: 7
Action_Type and Days_Out fields are located in a database named "Action". Date_In is a field in the main database named "Cases".
On my form I can select the "Action_Type" from a combo box and update the linked field in the "Cases" database. However, I am not able to retrieve the assocated "Days_Out" value for calculation.
In the above example I would like to display the result: 03/15/2002