Hello i am new in access, and i try to build inventory system with access. I have problem when i make queries in total stock, i have error notification that "specified field could refer to more one table listed ". Anyone can help me please...thanks
Novice
Windows 10 
Access 2016
Hello i am new in access, and i try to build inventory system with access. I have problem when i make queries in total stock, i have error notification that "specified field could refer to more one table listed ". Anyone can help me please...thanks
Who is John Galt?
Windows XP Access 2007
The error message is quite clear. The field idbrg exists in more than one table specified in the query, so you have to tell it which one you want to use:
TableName.FieldName
Simple table relationships ("faces" to "spaces" to "chairs")
Enter "yes" or "no" in a table field based on another table
Posting Permissions
Reply With Quote