Ok I am back with my call log database and my manager would like some changes (go figure), so basically he wants a call view form and a search form added.
The main form (frmCallList) lists all calls for the day and has a option to view by shift. But it only shows the information from the call table (tblCalls). What the want is a button to open the selected call in the list in another form but displays all details associated to that call in a list form. I have dubbed this frmCallView. I tried using a query but still learning this I don’t know how to separate the details in the query to the list box or if I am even on the right track.
The search form is basically a keyword search (never done this before) on the calls table and details table. It will have a search button and a list of calls not details will display in a list box (yes they have a thing for list boxes). There should also be a view call button like the one I talked about earlier (I am assuming it’s the same code). There is a high probability of needing it to exporting the results to a report or file but with the details.
I am concerned I do not have this set up correctly (I know the New Call button doesn’t work right). I can tell you I don’t like the form calls and how we currently have to update a call. I was thinking that there should be two forms; one for new calls where one enter the new call and the first detail for the call, and one for updating the call where one is adding a new detail to the call but the detail is still associated to that call. I don’t know; I am open to suggestions.
This was supposed to be simple.
I have attached the file.