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
This PTG archive page provided courtesy of Moy Piano Service, LLC