Hey guys,
So i have two tables, one being child to the other, first one is called "jobs" with a formatted primary key being job-0001, job-0002 etc...
The second table is "quotation" table, it has a field called jobs linked to the primary key of the "jobs" table with a lookup wizard established while creating the "quotation" table.
My issue is that when i'm filling up an entry in the quotation table and selecting the related job to its quotation, i'm getting the below message:
"The value you entered does not match the number data type in this column"
I know why this is happening since the primary key has letters in it and the lookup wizard is numerical.
Any way i can go around this issue and still get the result i want?
So i have two tables, one being child to the other, first one is called "jobs" with a formatted primary key being job-0001, job-0002 etc...
The second table is "quotation" table, it has a field called jobs linked to the primary key of the "jobs" table with a lookup wizard established while creating the "quotation" table.
My issue is that when i'm filling up an entry in the quotation table and selecting the related job to its quotation, i'm getting the below message:
"The value you entered does not match the number data type in this column"
I know why this is happening since the primary key has letters in it and the lookup wizard is numerical.
Any way i can go around this issue and still get the result i want?