models

[Don Mannino]

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