Hello,
I've posted before about this project I'm working on, and got a lot a help from the forum, and now I'm adding another post on how to better structure it.
The project is for a construction company and will help them with their estimation for various projects. They receive an Excel file with a lot of lines where they need to estimate how much that would cost(i.e. one line might be: "Installing steel pipes, category 1, size 20 cm").
The user imports it in Access, uses a series of dependent drop-downs to select the correct categories and then gets the correct price from the db.
I'm using a intermediate table to store all this data for each project. When it comes to export, I'm exporting only 3 main columns. When I'm opening a new project the intermediate table gets erased and the new data is pulled in.
The question revolves around how to store the intermediate versions of each project(i.e. if the user closes the computer, starts a new project..). Should I save the intermediate table with all its columns in a excel file in a hidden folder? Not sure how professionals are doing this .
Thanks,
George
I've posted before about this project I'm working on, and got a lot a help from the forum, and now I'm adding another post on how to better structure it.
The project is for a construction company and will help them with their estimation for various projects. They receive an Excel file with a lot of lines where they need to estimate how much that would cost(i.e. one line might be: "Installing steel pipes, category 1, size 20 cm").
The user imports it in Access, uses a series of dependent drop-downs to select the correct categories and then gets the correct price from the db.
I'm using a intermediate table to store all this data for each project. When it comes to export, I'm exporting only 3 main columns. When I'm opening a new project the intermediate table gets erased and the new data is pulled in.
The question revolves around how to store the intermediate versions of each project(i.e. if the user closes the computer, starts a new project..). Should I save the intermediate table with all its columns in a excel file in a hidden folder? Not sure how professionals are doing this .
Thanks,
George