Now I will be creating a database for four nuclear power plants. The purpose will be tracking the testing and training of the plant operators. From this the company will also be able to assess what a crew would be capable of based on test results of individuals. This way they can combine individuals with respect to their strengths and weaknesses so as to have all crews meet certain standards.
A new challenge is before us. Migrating a FileMaker Pro database on a Mac OSX machine to MySQL on a hosted server. So we can handle Mac and PC implementations.
I enjoy the discovery phase of a project; learning a new business, seeing how other people arrange and manage their business. No two businesses are the same. There lies the shortfall of software packages. They are not able to be tailored to suit each unique situation. Instead you have to adapt your organization to fit the Software. That is not a way to purchase software. Every company needs software tailored to how they do their business. It always is easier to adapt your custom software than it is to change the way people do their jobs.
I find that when developing a proposal, if I give the client a graphic display of their database as it would look to the user, that they are better equiped to help me design the database the way they want it the first time and not after many revisions.
I do a weekly download from a .csv file (for my client).
They want to visually compare the orig data (in a form) to the new data.Â Then they may or may not want to accept any data changes.
So I’m building them a data comparison form (pop up) to lie on top of the current (old) data.Â I’m changing colors on the popup form to visually indicate which data has changed.Â And I’m adding a function to the double click event of the controls so they may easily accept the changes.Â Why a function?Â so I won’t clutter the coded window and so I can handle the various currentdb.execute update statements all in one place.
But here’s what I’d like to know:Â From the properties window of the popup form, how do I pass in the name of the control in the function in the double click event?Â That sure would have saved me a lot of time!