I am new to filemaker and I would like to do a chart report but I have some issue with it.

 

Here is my question, I have database with several tables that each has a input_date and a primary key (Mobile number) to link to a main account table and layout.

.

Table A 

mobile_no

input_date

Field 1 

 

Table B

mobile_no

input_date

Field 2

 

Table C

mobile_no

input_date

Field 3

 

Table Account

mobile_no

 

 

However, how can I create a chart layout  such that it will display like this.

(Line Chart - Table A)   ->   I tried to set but it either displaying the graph wrongly or only display 1 input_date.

X - Axis:  input_date

Y - Axis: Field1

 

(Pie Chart )   ->  I want to display a static chart for both TableA:Field 1, TableB:Field2 & TableC:Field3  . But I dont know how to do it...

 

It's usually more helpful if you avoid names like tableA, tableB, field 1 etc., and instead tell us the real names of your tables and fields, and what their purpose is.

This seems to be another way of asking the same question:

http://fmforums.com/forum/topic/94001-how-to-do-a-date-mapping/

I removed the other post as a duplicate of this one.

 

@wchan83 welcome to the FMForums, 

 

Please don’t post your questions more than once. This is only one list,  and we will see your question where ever you post it. You only need to pick a topic that matches your question and post it. A short description of what is expected in each Topic Area is next to the Topic name.

 

Lee