Search results

I deleted the split form. If I make a new form or query from the Orders table values are not shoving, only ids. Why the previously made form shows values but new ones does not?

I have database for orders. Tables are Orders, Sales person, Customer and Products. Problem is that suddenly values aren't shown in fields if I make new query or form. Values are shown in forms which I have made previously. I was testing different options for user's main form. I was testing...

Thank you! Problem was the different data types. I changed id's to Customer_id etc. and changed datatypes in Orders table. Now it is working in this simple database and the real one. Now I can continue building the real one:)

That is only example database about the problem. I made simple database to find the problem but I haven't found it yet. If I can make this database work, I can make the real one work also.

Here is the db.

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...