models

[Don Mannino]

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