Hi, Rich. I need to do some work on the database that you created for me. I haven't heard from you in forever :-) Hope the baby came into this world healthy and happy!
Here is the link to the original project. I have made some changes to the database, so please start working with my updated copy attached, rather than your last version. [url removed, login to view]
I need the BOMData form to not expand the kits into their list of components. I want that fuction to not happen until the BOMSheet Report is printed. Basically I need this to happen dynamically every time I print a BOMSheet report so that the data is updated and current everytime I print a new report. The BOMData form should simply list the main Kit Part Number and quantity info...not the individual components of all the kits. As it is now, if I change the components included in a kit and then go to an old Project that includes that kit...that kit will not update to show the current kit details...it will hold the old. That is why I need it to be dynamic to update everytime I run a BOMSheet report. Please advise how much this change will cost and how fast you can make that happen. Thank you!