Recent content by mike60smart

OK

Yes just remove any confidential data

Can you upload a copy of your database?

It would help if we could see the FE?

I tidied up the main tables as shown in the attached screenshot

Sorry but your tables and relationships do not make sense to me. Points I have picked up are as follows:- Numerous Lookup field in numerous tables. You should not have any spaces in fieldnames or any non numerical characters ie !"£$%^&*(){}[]?><~@ Some of your Joins between tables do not have...

Can you explain each of the 3 Transactions please.

Hi Which are the table that you are thinking of modifying?

Difficult to make out your relationships from the screenshot. Are you able to upload a copy of the database with no confidential data?

Hi Gasman It is PrintPreview in my copy.

Database opens fine with no errors.

ok

Are you able to upload a copy of the database that crashed?

Are you able to upload a copy of the actual application?

Hi The rptRevHistory opens in PrintPreview for me?