Order Call Log
Budget: $30 – $250 USD
Created In Microsoft Access - I want a simple data base that holds prior customer orders and allows me to query customers based on prior purchase date or dollars spent - and then when I call them, allow the call result to be tracked in a newly created table.
I will constantly replace the order history file.
Actual sample file attached and field map document attached.
Have a parent form with the "Top" customer fields, and a sub form with the "bottom" order fields... and build a third sub form (and tables) to display call history.
Then create another sub form so I can enter the results of my phone or text contact with these customers.
When I run a query, I am envisioning one page per customer, with all of their order history and all of their prior call history displaying. So, if I query customers who purchased between 2/1/2022 an d2/14/2022, I would like to see all the customers, and all of their order history regardless of date, and any contact we ever had with them.
I will constantly replace the order history file.
Actual sample file attached and field map document attached.
Have a parent form with the "Top" customer fields, and a sub form with the "bottom" order fields... and build a third sub form (and tables) to display call history.
Then create another sub form so I can enter the results of my phone or text contact with these customers.
When I run a query, I am envisioning one page per customer, with all of their order history and all of their prior call history displaying. So, if I query customers who purchased between 2/1/2022 an d2/14/2022, I would like to see all the customers, and all of their order history regardless of date, and any contact we ever had with them.