I have a relationship that has been working a treat.

Until now... I have just discovered the reason and hopefully some one can help.

The reltionship is:

Table A

1. number field: Field A

2. Text Field: Field B

2. CalcField: Field A + 50

Table B

1. Field A (number)

2. Field B (text)

Table A Table B

Field A > field A

C_field A < Field A

Field B = Field B

This relationship gives me all the values that that fall within my tolerance band. great, it works....

However, it only works as long as my field A in Table A stays below 949.

Then anything over that means that C_fieldA is over 1000 which confuses the relationship into thinking that its 1 or something....

Thats the only thing I can work out and its taken me ages??

Is there any way to overcome the fact that the figure is 1000 and not 1.... I hope this makes sense.

Ben

sta

One of the calc'fields must return a value in text instead of number!

--sd

Hi Ben:

In addition to Søren's post ...

Table A Table B

Field A > field A

C_field A < Field A

Double-check me here, but I don't think there are any Real numbers that can satisfy these predicates, where ...

x > y, and

x + 50 < y

However, it only works as long as my field A in Table A stays below 949.... Then anything over that means that C_fieldA is over 1000 which confuses the relationship into thinking that its 1 or something.... Is there any way to overcome the fact that the figure is 1000 and not 1....

If the teaser above doesn't cure it, can you confirm that you're running the most recent updates to Version8?

Hope this helps.

Ummm, Its funny how it worked. I actually had the field A in table B as a text field (one of thos things.

Changed it to a number and that worked with figures over 1000.

Likewise, yes SØren. this also worked by changing the calculation field to return a text field.

Regards,

Ben

But the choise of type should be number on both sides, otherwise should leading zero's be used on both sides:

Right("0000" & theNumber;5)

You best see this if you sort on the field without this leading zero scheme, when the order turns out to be:

1

10

100

11

12

--sd

SØren,

so how do you sort so the numbers are in correct number order?

1

10

11

12

100

:

See if this tread helps Link