Greg, My point (not well made) was that you will gradually build up that list of models as you enter customer data. I don't know of any comprehensive list of piano models, and in the case of Kawai I still don't know all of the models our company has produced over time and for all countries. Don At 09:19 PM 6/6/2005, you wrote: >Don, > This gives me a leg up on the how. Thanks! But what I really > asked was where to find the list of models from each manufacturer. Sorry > if I was unclear. > >Greg > > >At 11:24 PM 6/6/2005, you wrote: >>Greg, >> >>You will need to create a second data file which contains brand name and >>models. Link it to your customer database according to the piano >>brand. Your customer data screen will have the brand field in the >>customer database file, then it will have the model field from the piano >>brand/model database file. >> >>Simple format them both as drop-down lists (I am not familiar with >>filemaker pro, but I presume this is not difficult). If you select a >>brand like Kawai which has a bazillion models, you should create a button >>which switches you to the piano/model database view, and you can simply >>enter the model in there. Jump back to the customer screen, and the >>model should join the list of available models in the model drop down field. >> >>I think it is easier just to type in the model, but what the heck - >>relational databases are fun. >> >>Don Mannino RPT >> >> >>At 08:17 PM 6/6/2005, you wrote: >>>Greetings fellow list members, >>> I am beginning to develop a Filemaker Pro database and I need >>> to populate a pull down list for piano model. I want to do this based >>> on manufacturer which will be no small task. For instance if I pick the >>> brand Steinway then I hope to have available choices of model like S, >>> M, L, B or D or others that they alone have made. My question is >>> whether anyone knows of a place where I might obtain not only a list of >>> manufacturer names (Pierce) but also a listing of what models each >>> manufacturer produced. Anyone know of such a source? Actually >>> surprising that Pierce Atlas doesn't contain this come to think of it. >>> >>>best, >>>Greg >>> >>>Greg Newell >>>Greg's piano Forté >>>mailto:gnewell@ameritech.net >>> >>>_______________________________________________ >>>pianotech list info: https://www.moypiano.com/resources/#archives >> >> >>_______________________________________________ >>pianotech list info: https://www.moypiano.com/resources/#archives > >Greg Newell >Greg's piano Forté >mailto:gnewell@ameritech.net > >_______________________________________________ >pianotech list info: https://www.moypiano.com/resources/#archives
This PTG archive page provided courtesy of Moy Piano Service, LLC