I had created 2 databases- a 'Policy' database & a 'Client' database.
Does that mean that you have two database files or two tables in the same file?
Two database files. Here are what I've done.
1st database file called 'Policy' - created a table called 'Data_Policy' in this Policy database file.
2nd database file called 'Client' - created 4 tables called 'Main', 'Address', 'Tel', 'Email' in this Client database file.
All tables have the field ClientID to identify each client & policy.
All client data could show in the layout of the Policy database.
Does this mean that you've defined external data source references for each of the tables from Client in your Policy Table?
On what table occurrence is that layout based? Policy? Client? or ???
and how is the Tel data displayed on that table? In a single field or a portal?
If a portal, is there a filter defined for the portal?
And you may want to run a recover on both files to check them for damage and rebuild the indexes in each file.
I've decided to rebuild the database files to see if they work well.