N-N Relations

Applications Forms
#1

I have created a form with N-N Relations.
One keyfield is a char(4) field, it contains a reference code to cities, example: 0599, 0546.
In the relation table however de 0’s (zeros) are ignored and are saved in the table as 599, 546

This is a problem because a select in another form is based on this value and it compares it with the code table where the saved values are 0599, 0546 and so on.

Does somebody has a solution.

John den Os
Leiden
Netherlands

#2

Re: N-N Relations

Maybe you have configured the field like Numeric or Decimal type. This field must be a alphanumeric field.
JG

#3

Re: N-N Relations

Thanks JG for your attention.

I solved the problem, the hard way.
I dropped the table and I created it again.
I dropped the form and I created it again.
Now it works fine.