nardella
09-02-2010, 07:31 AM
I am working on a database with two related tables - similar to a database that has one table with a list of clients and a related table that holds each client's order.
My primary table tracks the progress of our company projects through a series of processes across different business areas. The second table (an actions table) has been designed to provide additional information for a specific department and the actions taken by this department for each company project . For any particular project, there will be multiple actions.
I have created a primary form that will display the details of the primary table (which, again, tracks the life of a project). I have added a control on this main form to open an actions form.
HERE'S WHERE I'M STUCK.
I need the actions form to open as a new record for the currect project.
My primary table tracks the progress of our company projects through a series of processes across different business areas. The second table (an actions table) has been designed to provide additional information for a specific department and the actions taken by this department for each company project . For any particular project, there will be multiple actions.
I have created a primary form that will display the details of the primary table (which, again, tracks the life of a project). I have added a control on this main form to open an actions form.
HERE'S WHERE I'M STUCK.
I need the actions form to open as a new record for the currect project.