Denise2020
Member
- Local time
- Today, 19:38
- Joined
- Mar 31, 2020
- Messages
- 82
I am trying something and I am not sure if this is the "right" solution to my problem, or whether it is possible, so I am open to all suggestions!
I have a database that has a table that records incoming help requests from external sources. We can call this External Support. I created a form to record new external help requests. Sometimes these help requests cause internal jobs, and I am creating a separate table for the internal jobs. We can call this RFI (Requests for Information).
An example of this would be an external agency finds an object that they need to identify and they call us. That would be on the external task list. We identify the object but realize that we don't have good information on it and need to update our own records. This would be the RFI/internal task list. This is at the request of my boss, who wants them divided in this way, unless there is a better solution.
So my first question is, should this even be two separate tables, or should it be one table with an identifier of whether it is external or internal?
My second question is if it DOES go into two separate tables, would there be a way, via my form, to enter data from the New External Task ALSO into the Internal Task list by checking a box?
I apologize, as I type this, I realize how completely convoluted and confusing this sounds but I cannot seem to explain it better. Thank you in advance!
I have a database that has a table that records incoming help requests from external sources. We can call this External Support. I created a form to record new external help requests. Sometimes these help requests cause internal jobs, and I am creating a separate table for the internal jobs. We can call this RFI (Requests for Information).
An example of this would be an external agency finds an object that they need to identify and they call us. That would be on the external task list. We identify the object but realize that we don't have good information on it and need to update our own records. This would be the RFI/internal task list. This is at the request of my boss, who wants them divided in this way, unless there is a better solution.
So my first question is, should this even be two separate tables, or should it be one table with an identifier of whether it is external or internal?
My second question is if it DOES go into two separate tables, would there be a way, via my form, to enter data from the New External Task ALSO into the Internal Task list by checking a box?
I apologize, as I type this, I realize how completely convoluted and confusing this sounds but I cannot seem to explain it better. Thank you in advance!