To join two fields, the data types must match. Text to text. Long to long. I would suggest adding Autonumbers to your main table in addition to your other PK. Use those for relationships. Otherwise, you could still use the current alphanumeric field as a FK, but you have to have the same field type in the other table.
آموزش کاربردی بود خیلی استفاده کردم. سپاس از شما
خواهش میکنم
Primary key is alpha numberic (customized ) auto number. How to use this field as a foreign key. Problem is data type conflict
To join two fields, the data types must match. Text to text. Long to long. I would suggest adding Autonumbers to your main table in addition to your other PK. Use those for relationships. Otherwise, you could still use the current alphanumeric field as a FK, but you have to have the same field type in the other table.