Product Tracing on FileMaker Portal Problem

[seorniyc]

Hello...

 

Firstly Thanks All forum member. I learn many special feature on file maker by this forum.

 

Im newbie on filemaker... I want build some special software for my business..

 

Now I need help.

 

I Have 3 tables.

 

1- Product

ID (Matching Field)
Name
Etc.. ( any spesification for this product. not important )

 

2- Buying Details
ID (Match Product ID)
Quantity
Price
Total Price ( quantity * price )
and below sum total price (sum= total of total Price)

 

3- Selling Details

ID (Match Product ID)
Quantity
Price
Total Price ( quantity * price )
and below sum total price (sum= total of total Price)

 

--- My main layout is Product layouts. Buying and selling details view on portal.

 

(Buying and Selling jpg on attach..)

 

But my problem start here.

 

I add another loyout for report how many buy&sell.

 

I buy item on 2 times, sell 1 times.

 

On report buying see 2 times but selling almost 2. But I sell 1 time..

 

I change field property ( try index type, etc.. ) but nothing change...

 

Please help me. Thank you.

[nozbilenler]

Türkçe direk mesaj atabilirsen belki yardımcı olabilirim.

[Lee Smith]

What did you say?

[LaRetta]

Buying and Selling tables contain same fields and should be in same table with a Type field saying which it is. Sometimes you can go by whether quantity is plus or minus to determine the Type but not always since reversals could be required.

Once tables are combined, reporting becomes simple and summary fields take care of the rest. :-)

[seorniyc]

Sorry for bad english. Ok. I explain my problem again.

 

Firstly I have product table. This table including product name, part number etc details. 
I show this details on product layouts. Near this information; I have 2 tabs. Order and selling.

 

Order: How many quantity, when, order number.

Selling : How many quantity, invoice no, sell date.

 

I prepare example for this problem. Please look attach image file. (problem.jpg)

 

and I send my table's relationship. (relation.jpg)

 

 

How I can report detail of my products?

 

 

[LaRetta]

Your English is very good but my prior suggestion still stands ... Buying and Selling are best handled by having them in the same table to begin with. Using a Type field separates them so you can still display them in different portals but they are truly the SAME entity ... transactions of a Product.

The reason your setup won't work (easily) is because there can be different numbers of buying and selling and, although you can use sliding portal (for one side or the other while reporting from the other child) it isn't suggested here since your current model would continue to cause you problems down the line.

If you combine the Buying and Selling tables, also combine their lines and your solution will become MUCH easier. :-)