Hello to everybody! This is my first database and probably problem is quite small but I can't find solution to it.
I have problem with query which is showing ID instead of value.
I have 3 tables, Orders, Customers and Products. All fields are text boxies, no lookups.
Data is inserted to Orders table with Orders_form where is Lookup combo boxies and lookup tables are Customers and Products.
Form is showing values (customer and product names) but query shows only id's. I have tried everything I have found with google to solve this but nothing has helped.
Tried to join tables in query, after that query shows nothing. If tables are not joined query shows id's.
I have problem with query which is showing ID instead of value.
I have 3 tables, Orders, Customers and Products. All fields are text boxies, no lookups.
Data is inserted to Orders table with Orders_form where is Lookup combo boxies and lookup tables are Customers and Products.
Form is showing values (customer and product names) but query shows only id's. I have tried everything I have found with google to solve this but nothing has helped.
Tried to join tables in query, after that query shows nothing. If tables are not joined query shows id's.