link invoice - customer - article

[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

[LaRetta]

Hi Mille,

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 ??

Just as Invoices is many to one customer, you need a LineItems table to hold the multiple selections of articles on one Invoice.

Check out this Invoice demo by Comment . :smile2: