Search results

Can you upload a copy of your current database?

Hi Raymond Could you upload a copy of the database with no confidential data?

I would go with Ken's solution and import all your data into his table structure.

Are you able to upload a copy of the database without any confidential data?

Hi Jack I take it that 1 Service Request could end up having 1 or more actual appointments to fix the problem?

Can you explain what you mean by Dispatch?

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?