Amateur FileMaker Pro 12 User
I am very new to FileMaker and have never created a database. I'm pretty confident that I can do it but I'm having trouble with the design of the database. I want to create a table that lists various raw materials and their costs and another table that breaks down the final product by the % of the several raw materials used to create the product. I then want to be able to show the cost breakdown of each product by the % of each raw material used. I believe I have a many to many relationship which I understand makes things more difficult. Does anyone have any suggestions that might help me?