Gregor Alessi

Hello comment Thank you. I'm impressed how kind (all of) you are towards newbies on this forum, providing such detailed answers. I don't get enough time to get into FM (I'm a full time sysadmin, studying CS alongside work)... I hope you can accept my excuse for not replying in such a long time. I already had a GID in db_groups, but I couldn't find the right way to "explore" the options. I learn by relating to what works for sure, then abstracting my knowledge. So far the tutorial has served me well, but it was not yet enough for this issue, although it was mentioned. You helped me a lot. It worked. If I may ask another related question: In UML class diagrams we use the definition "cardinality" to specify how many objects can be instanced. I don't know the correct terms for ERDs. Anyway, here it comes as in a class diagram: In db_groups I want ::article_group to be unique (cardinality:1..1), in db_articles::article_group I want the (now related) field to get its content from db_groups, but with a cardinality of 0..*, which means there may be none up to infinitely many occurences of article_group (as specified in db_groups). This is what I described in plain english in my original post. How would an experienced FMP developer solve this? Just like me, using value lists, that get their entries from db_groups? The work-around with the pop-up-menus doesn't look promising in an application that should be in use for 5+ years. On a sidenote: I think a "Read The Fine Manual" is good enough as an answer to this question, if you want to keep it short. What would help me a lot, would be the keywords that I should delve in or a specific chapter/book I should have an eye on. Thank you again! --greg The goal is to have a stock software for a public primary school, including an inventory based on orders sent to suppliers and "sales" to teachers. I will release the beta under GPL, if there ever is one :-/

Hi all I am new to FileMaker and Databases in General. My first small project is to create a pricelist for a small store with 20 articles. === The Setting === I have two databases which are not directly related: db_articles db_groups Plus, there is a value list vl_groups which is defined to contain the entries from db_groups::article_group the field db_articles::group has the following options set: Validation: Always, Do *not* Allow to override, Not emtpy, Member of value list: vl_groups. The field db_groups::article_group is defined to only contain unique entries, and not to allow user override. In the layout, the field setup for db_articles::group is as follows: Drop down list, Display values from vl_articles, Include aroow, Auto-complete. === Let's put it together === Let's say I have five articles that have a value in db_articles:group named "paper". As expected, I get a pull down menu that shows me this value, as I entered it before in db_groups:article_group. Now, I decide to change the entry paper in db_groups to "Papier", the German translation. === The Problem === The five articles don't reflect the change. Only new records will get "Papier" - the old records I have to change manually. What would you recommend to get around that? Is there a built-in functionality to achieve that or do I have to use a script? --greg