Hallo ggunners,
Many thanks for the reply. I added the data today. I made a upload to my site of the result so far. DON'T EXPECT IT WILL RUN ALLREADY! I just want to check if I am working in the right direction. Hope somebody (or many) can approve or tell me where I went wrong.
WHere to find the database? Go see (sorry for the looong URL).
What can you see when opening this file in Access (part of MS OFFICE)? OK, two forms are working for 90% (engine list and polar-general data). I still haven't figured out how to make those buttons (previous and next) work right. I hope my friend Bart will do so when he is back from his holidays. I am very proud about the polar form (Airfoil). I have found out how to show the details (cl,cm and so) when you change the record of the aifoil you look at (click those little arrows at the bottom of the form). Those are two forms combined. Never done before ... and it works. YAHOOOOO. :p
In the tables you can see that I worked on their content. Just see if I grouped logically the data. Remember, I grouped them so you call choose the general data of a part and change the specific data for your model. For instance: You can choose a engine-prop combination which is already been used, but you can change the psition of the prop and the direction of the thrustline. those things are "personal" for each model. Those "personal" data are placed in the table "model_general data".
I hope you can still follow.
I will continue to work on this database. I hope you can guide me to a Access-wizard who wants to help as long as Bart is on holidays (two weeks, I guess). I could use his advise.
The filling of the lists, that part is a job for the FMS-fans. I hope they will be able to make a good list of engine-prop combinations. Use a single mark to begin with (OS Max for instance). Use their oficial data to make it reliable. Contact them if you cannot find the data. They sure will be happy to see THEIR engines in such a program. I think to recall that there is a graph being used to choose the right prop for a engine. Can somebody guide me to that graph? It has the seize and pitch on it in relation to ... I guess ... speed??? It might be a good tool to make reliable engine-prop combinations.
Sorry, haven't found out a way to copy the data from one combination to another. it will be a lot of typing at the beginning. Sorry. ???
Well, this is it for today. I hope ... hope ... I will have time to work further on this database tomorrow. We will see.
Keep that brain spawning wings,
Koen
PS. Now I go see the "Lord of the Rings" DVD I got for my birthday. Yep, 38 years old ... and still likes elves, dwarfs, dragons and so.
