Sum() and control field input

[lindahedlund73]

Hello,

I have to registers: Inventory and Deliveries. Inventory includes the fields Articlenumber and Amount (where Articlenumber must be unique). Deliveries includes the fields Ordernumber, Articlenumber and Amount. I have a relation between Articlenumber in the both fields. In the Amount field in Inventory i have this function: Sum(Deliveries::Amount)

Some of the Articlenumbers that I am testing this database with include a dash (-), for example 97-683. Somehow this seems to confuse the calculation in the Amount field, which I find strange... So that the balance is not shown right in the Inventory register (that is it doesn't result in the amount that the deliveries add up to). It only sums wrong when the articlenumber include this dash. For the articlenumber that is for example KO33 it works perfect.

So now I would like to find out if there is a way to keep the dash in the articlenumber and still get a correct sum or otherwise I would like to find out how to make sure that a user can write anything in the articlenumber field BUT a dash (-) since this seems to "confuse a calculation that involves a relation with this field"... That is; it is ok that a user write numbers and text in different lengths in the field all mixed together but no dash. Can someone help a beginner...? Many thanks in advance //Linda

[LiveOak]

In define fields, change the indexing on the article number field in both files to "ASCII".

-bd

[tlsparker]

Make sure Articlenumber is a text field in both files. If Articlenumber is a calculation field, make sure the calculation result is text (at the bottom of the calculation dialog). I sometimes use social security numbers with dashes as relationship keys, and they work fine. They must be text fields, however.

[lindahedlund73]

Thanks! It works when changed to "text". Have a good weekend. See you later. Linda