samuel@felfel.ch

Hi I have a problem with sorting. I need this to properly create food labels. A certain product (e.g. chicken sandwich) contains several ingredients (Chicken, Butter, Tomato, Wheat, etc.). These ingredients have to appear on the food label in descending order based on their weight. Amongst others, I have a table called "Recipe" with the fields "Product Name", "Ingredient", "Amount in g". Here, I add all the ingredients of a certain product together with the corresponding amount (in grams) of each ingredient. There is also another field in this table called "Ingredient_Label_List_S", which is a statistics field that sorts all the ingredients of a product (e.g. chicken sandwich) in descending order based on the field "amoung in g". So far so good...however, i need the information "Ingredient_Label_List_S" in another table called "Products". In the table "Products" I have a field where I enter the formula "=Recipe::Ingredient_Label_List_S". The problem is, that in this field the ingredients are no sorted anymore. How can I solve this issue? Thanks Sam

Hi all Is there a way to multiply a data record? For example, I need to make 6 copies of a certain data record. And I would like to do this as fast as possible as I have to multiply a lot of data records. Something like a button in the entry mask where I could chose how many times i would like to multiply the data record would be great. Your input is more than welcome;)

I'm new to filemaker pro advanced 13 and encountered some problems with the case function. I have to following function: Case ( Product ID = Order Book_Test::ProductID ; Case ( Order Book_Test::Eformat = "Date&Price" ; Case ( Order Book_Test::Date = ( Get (CurrentDate)); Count ( Order Book_Test::Eformat)))) my problem is that filemaker stops at the first true Case. However, I need filemaker to validate all Cases and based on this result to execute the Count function. How can i solve this issue? Thanks Sam