Invoicing with FM

[ilnave]

Hi everybody,

this is my first post here as I have just recently landed on FileMaker.

I am trying to develop a simple program that my mother will have to use for her job.

Basically she will have to input several fields in tables and then she should be able to use those data to:

-track orders

-generate invoices

I have some knowledge with MS Access but I am looking into FM as I am using a Mac and she is using a PC, plus I would like to make somehting graphically more evolved than Access.

The structure:

Table 1: client contacts (name, address, email...)

Table 2: client order numbers (name, order number, order date)

Table 3: order detail (order number, article, quantity, unit price, total price [calculated].

!!A single order number can include multiple order lines!!

I would like to know:

Is there a way to use these tables and of course the appropriate relationships to generate invoices (and other documents) that look like:

Client name

Date

Order number

article 1, unit price, total price

article 2, unit price, total price

GRAND TOTAL

"and here leave some space for custom notes"

I am having an hard time because what I am able to generate is a sort of table that for every order line within the same order repeats the client name and order number and date and so on.

I would like to show the client name and order number once, and then all the details should follow.

I hope my request is clear.

Thank you very much in advance

Regards

[RodSierra]

You may want to check out this free solution on the FM site, it can give you some insight on one of many structures possible, and give a base to work from:

http://developer.filemaker.com/solutions/detail/?item=solution.10000000539&sol_region_amr=1

There are also a tonne of posts here about this type of structuring, suggest you take a bit of time and do some searches.

[comment]

See if this helps:

http://fmforums.com/forum/showpost.php?post/309136/

[ilnave]

thank you very much for the link, I have downloaded it and I am now customizing to my needs.

I was short on time and could not dedicate proper attention to searching previous posts, my apologies.

[ilnave]

This too is very helpful, because it allows me to understand the way the DB is built. The FM productivity tool is very complex and thus far more complicated to understand.

Thank you very much

Regards

[ilnave]

See if this helps:

http://fmforums.com/forum/showpost.php?post/309136/

I have tried to customize this too.

When I go into the contacts layout module, I try to add fields (which of course I added in the table before), and here comes the problem.

The fields are blue and named ("powerful solutions", "customize buttons" ....) and I can't modify them. How could I do that? thanks