models

[Greg Newell]

Don,
         I see your point and you are probably right. I'm trying to avoid 
future mistakes by allowing only those models that a manufacturer actually 
makes to populate a defined list for that manufacturer. I'd hate to see a 
customers piano listing a Kawai "M" for example since it doesn't exist (to 
the best of my knowledge). This might be splitting hairs but I thought I'd 
try it at this early stage rather than want it and not be able to go back 
and make the corrections later. It would also be nice to have the 
historical data but that can be entered as you go, so to speak.

best,
Greg



At 10:35 PM 6/7/2005, you 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

Greg Newell
Greg's piano Forté
mailto:gnewell@ameritech.net