Repeating problem

[gregorytan]

Hi

I create a layout call Invoice and another layout call Product Cost.

On Invoice layout, i had 4 field, Run Format, Run Qty, Extent and Cost. On Product Cost layout i had Run Format, Base Run Qty, Extent and Cost.

My problem is that when i key in the Run Qty and the Extent, the Cost field only show one cost for the product cost layout, did not show the second and third cost.

Here also attach a example file

Need some help for this.

Thanks

Cheers

gregory

Re.fp7.zip

[NovaChan]

Can you elaborate on what you're trying to do here? You'll probably get more responses if it's more clear what you expect to be happening and why.

[Søren Dyhr]

You need to export and split the repeaters to individual records, and make them visible via a set of portals, to mimic the repeaters.

--sd

Re-1.zip

[gregorytan]

Hi Nova

try to create an invoice system. because we have different product and cost. So i want to setup this to do my invoice. i do not know this will work when using repeating to look for reference. I already run my Job Plan using the repeating on Run Qty and Extent.

[Søren Dyhr]

I already run my Job Plan using the repeating on Run Qty and Extent.

You have to take my word for it, but it's a development move you are very likely to regret very soon. Why not embrace relational design once and for all?

Ditch repeaters immediately, and do not take them up again for anything but utility purposes.

--sd

[gregorytan]

Hi Soren

Thanks for that. i will take your suggest. i will work on the suggestion to work on my flow. Thanks

[Søren Dyhr]

Perhaps it would be beneficial to know how to keep one the straight and narrow, until you know enough to break the rules?

Invoicing should look as something in the vicinity of this:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

However ....the crucial knowledge to make filemaker as tool behave relational is this:

http://www.fmp.it/download/files/FM7_key_concepts.pdf

--sd

[Søren Dyhr]

Not that it differs particular from JMO's but yes indeed let's keep it in the family!

--sd

[gregorytan]

Hi Soren

Need your help again, How can i total the data from the 3 Protal Initial Row into One.

eg: Initial Row 1 Number of Row 1

Initial Row 2 Number of Row 1

Initial Row 3 Number of Row 1

Need to Total all this Row Data.

Thanks

Gregory

[Søren Dyhr]

If you are referring to the template I made you earlier on in this thread? Is there something you need to be aware of when invoicing. Prices in the stock might change, but an invoice is a historic document which should be a snapshot of the current prices when issued.

This mean that a lookup needs to be instated into the join table before summing ... because if we just summed at the prices found in the records arriving into our portal tunneled would a slight change of price cause a havoc in all invoices carrying the item changed.

The summing is then done over the records in the join table instead of the live values. I have made a refresher calc in the lookup, which could be done in several ways and the Evaluate( function is dedicated for this very purpose ... I simply just do it that way because when things in quotes should go into the internal calc should the random quote in the statement be esc slashed, but that shouldn't keep you for doing so though!

But take a look at the changes I made to my template! I do however have a slight suspicion that what you actually wish to have is a less rigid quantum entry to calculate the price, if you enter only 1998 pcs or 1999 pcs should the price be a higher one than when reaching 2000 pcs? As it was in you original template was the choise "whole sets" and nowhere near a flexible price matrix?

--sd

Re-2.zip

[gregorytan]

Hi

Thanks for your help. I will work on it let you know later. Thanks again.

cheers

gregory