This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 22%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
When I create 2 tables in access and make a relationship between them.
When I press plus sign in the first table it shows me a ( One of your parameters invalid )
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 92%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECQ%3C/text%3E%3C/svg%3E)
Hi, @Hadeel Adel Johar Al blushi
We need more information to help you with this issue. Can you please provide a screenshot of another table as well as the relationship between the two tables?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 17%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Hello. I had the same problem that I could finally solve. Main table index was set to large number. I changed it to number and it worked. All relationships were okay, I made a query to check and got the data as it should be. I hope it can help.
As it shown in the first image There's plus sign I highlight it with red color, every time I press it it shows ( One of the parameters invalid )
I uploaded the relationship image + The other table
Hi, @Hadeel Adel Johar Al blushi
We suggest you to check the settings of SubdatasheetName in Employee table. You can check it by go to design view of Employee table, then right click ant content of the table and choose properties. Then in Property Sheet, set the Subdatasheet name to General Info and save the change.
Hi, @Hadeel Adel Johar Al blushi
Just checking in to see if the information is useful. Please feel free to let us know if you need further assistance.
Hi, @Hadeel Adel Johar Al blushi
Is your problem solved?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 73%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOS%3C/text%3E%3C/svg%3E)
Large number make this error but in some systems we can use relationship with large number with out any error ! New systems don't encounter this error! But old system can not handle the large number so if you can't convert it to number you should change the format into short text in two tables ! This way problem will resolve!
What are the data types of the Iqama columns in the two tables? From your screenshot, that in Employees is clearly a number, which I assume to be the identification number of the residence permit. Normally a long integer number (as set in the column's Field Size property in table design view) would be used in the case of a key like this. The data type must be the same in both tables.
Note that in a one-to-one relationship type like this one of the tables, almost certainly Employees in your case, must be the referenced table in the relationship.
What happens if you join the tables on the Iqama columns in a query?