Greg, What you can do in Filemaker is that the field for Model or Make, for example, can be "indexed" in the Define Fields dialog box. This means that, in addition to, or instead of a "pop-up" field, you can just click into the field and type Command-I (Control-I in Windows) which brings up an alphabetized list of every entry ever made in that field. This may not be what you're asking. Is this to be used as an aid to typing information into a database? If you are wanting to compile a complete list of piano makers and their models, Larry Fine's Annual Supplement to The Piano Book would be a good resource - nearly 100 pages of piano models currently being produced. Tom Cole Don Mannino wrote: > 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 > > > > _______________________________________________ > pianotech list info: https://www.moypiano.com/resources/#archives > >
This PTG archive page provided courtesy of Moy Piano Service, LLC