models

[Greg Newell]

Tom,
         Obviously you have used FileMaker and have a pretty good idea of 
what it does. I'm just getting around to using it myself and the learning 
curve is steep. See my reply to Don Mannino which explains a bit better 
what I am trying to do with this small segment of data. I may make it 
happen, I may not. Never know until you try, eh?

best,
Greg



At 11:33 PM 6/7/2005, you wrote:
>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
>>
>
>_______________________________________________
>pianotech list info: https://www.moypiano.com/resources/#archives

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