Mille M

Hi! I started using FM a couple of days ago so sorry if this is a low level q. This is what I want to do: I have 3 different databases: - invoice - customer - article (or you might call it inventory) I have a relation between invoice and customer via customer id, so when I create a new invoice I type the customer number and all related data (name, address...) is filled in. So far so good. I also have a relation between invoice and article via article id field. When I type an article id I get name of article price and so on BUT how do I do if I want several article rows in the invoice ?? Of course I want my customers to buy several articles but I don't know how to add more rows that collects data from the article db. At the end I want to summerize all rows get a total sum. I read something about portal but I don't really get it so if you have a recommendation please type it for a new fm user : . Another q, if I have a calculated field in the invoice that collects data from a related table. I.e I have a field that calculates a price, can I somehow if I need to be able to manually change the price although it's a calculated field? Thanks in Advance, Mille

I need to check. Another q that might be a part of a solution to this: If I in the Inventory table have following fields: Shipping ID Product ID Name of product Then in the Invoice table when typing the shipping id number I want a drop down menu in the product ID field that only shows the products ID's that belongs to that particular shipping ID. How do I make the relations here ? And how do I set up the fields ? Sorry for all these q but they are very important to me.

Unfortunatelly not =(

Hi again, Yes I have a relationship between the two tables matching on ProductID but it doesn't work =( I also tried to create a numeric field in the Inventory table and then just added a calculated value to it: Sum ( Deliveries::Quantity ) but it didn't show. Seems to be no "communication" between the two tables or am I doing anything else wrong ? Thanks in advande !

To start with, thanks a lot for your fast response! To answer your question, since I have a unique ID to all different products I'm thinking of withdrawing the amount entered in the invoice table from the total amount/quantity value in the post connected to that specific ID. So, if you have a product in Inventory: ID Name Total amount/quantity 123 seet123 100 Then when someone buys i.e 10 pieces of sweet123 and that is entered in the invoice I want the total amount/quantity in the Inventory to be reduced, in this exampel to 90.

I just started to work with FM so sorry if this question is on a too low level. I have a Delivery note table where I specify all products my customer bought. One of the fields is called "amount". I also have a table called Inventory where I have the total number of amount of each product. I.e: A customer buys 10 pieces of candy named sweet123. I want the amount field in this example with number 10 to subtract 10 from the total amount field in the Inventory table. So if I had 100 of sweet123 after this purchase it should say 90 in the total amount field of the Inventory table. Is this totally unclear or can anybody give me a tip ?! Please =)