Data mix in the database...

[haavar]

I have a problem with my database. When I'm writing in my data to the database via the forms, the data isn't in the correct order when I start the database up again. Its mixed up. I am using 6 tables and combining data. Why?
I have no relations in the actual tables, but some relations like queries.
What should I do? I am going crazy...hehe

 

[Krij]

I have a problem with my database. When I'm writing in my data to the database via the forms, the data isn't in the correct order when I start the database up again. Its mixed up. I am using 6 tables and combining data. Why?
I have no relations in the actual tables, but some relations like queries.
What should I do? I am going crazy...hehe

Designing a database requieres a good design with the tables. You need to see over your table relations and see if it is a way to more effectively relate tables.

Also, having a combo to pick values like: 'Skriv inn skap/PLS nr' would automatically fill other textboxes if tables are related correctly. Have the combo be filled at startup with all 'PLS' recorded in the database.

Or is this a field where you enter values and then produces 'Kanal gr 1' data and so on via code?

 

[haavar]

Not with code, just type in the data and it produces a record in the table. The database have worked very good until now. Suddenly the database are not working properly...

Designing a database requieres a good design with the tables. You need to see over your table relations and see if it is a way to more effectively relate tables.

Also, having a combo to pick values like: 'Skriv inn skap/PLS nr' would automatically fill other textboxes if tables are related correctly. Have the combo be filled at startup with all 'PLS' recorded in the database.

Or is this a field where you enter values and then produces 'Kanal gr 1' data and so on via code?

 

[haavar]

Access bug

I found the troublemaker! Access!! The version I use have a bug on Windows 2000 machines...someone who uses Access 2003? Pleased?

Not with code, just type in the data and it produces a record in the table. The database have worked very good until now. Suddenly the database are not working properly...