models

[Greg Newell]

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