Multiple duplicating records

[Pavel]

Hello,


I have problem with visualizing multiple records connected to 1 record. When moving between records in main Form there are duplicates I wish to remove but I don't know how and where the problem is coming from I will attack the database so u can look it up.


Regards,
Pavel

[isladogs]

I haven't got time to look now but 'attack' seems an appropriate word for a WW2 battles database

[Pavel]

It is far from finished so I just made the tables and queries just to try the relationships and how the database will handle. Not all the names will be same in the final ver.

[ArviLaanemets]

You have almost in all tables Lookup fields! No wonder you have problems!

The problem is, that when you remove a row in lookup source table, the lookup displays an empty field, but really there is a numeric value you can't see.

1. Remove all Lookups from tables;
2. You can enter some records into tables for testing manually, but you have to be careful to maintain data integrity. For real work with database, never let users access database tables directly - for this exists forms.

[Pavel]

Thank you for your help it really did solve the problem as for the names of the countries I now just added table"Countries" to the queries and it is now showing the names of the countries without the lookup