I have no freaking idea why this doesn't work.

[briggieschancy]

This is my ongoing problem. I have the issue with the top picture, right one is only for example.
Infuriating.

[June7]

First case:

Left field is autonumber (a number type), Right field is text type - must be a number type.

Second case:

Left field is number type, Right field is autonumber (a number type).

[briggieschancy]

I hope the right picture was clear enough, but on the second case, I was connecting "nottheid" field and "ID" field. I just inserted the numbers on the left field (and now it's a number type field), but I also did that on my first case with the right field.


To make a long answer short, how do I make my text type to a number type? My boxes contain all numeric characters and no alphabetic.

[ssanfu]

According to the Error message, you should change the FK field (in the right table in the image above) from a TEXT type field to a NUMBER (Long Integer), providing that the PK field in an autonumber/long integer.

What are the two field data types??
"ID Prilavlien" =
"ID naroZnika" =

[ssanfu]

Looks like I'm late to the party again......

[June7]

Open table in design view and change field type to Number Long Integer.

[briggieschancy]

According to the Error message, you should change the FK field (in the right table in the image above) from a TEXT type field to a NUMBER (Long Integer), providing that the PK field in an autonumber/long integer.

What are the two field data types??
"ID Prilavlien" =
"ID naroZnika" =

Phew, well therer we go. Completely crazy, I was tearing hair off my head over it, calculating and comparing to others why it didn't work. And I knew somethign was off when I wrote the line that it was indented to the left, but then I completely forgot about it. Dammit.


Anyway, hats off for getting so into it as to actually editing and fixing my picture!
You sir are a certified MVP, let me say.

THANK YOU to all! This was really infuriating haha

[ssanfu]

From both of us, you're welcome.

Yes, it took a little the time to edit the image, but I'd bet you understand RI a lot more now...


Good luck with your project.........

[briggieschancy]

Thank you very much.