Good morning! I hope all are well! I really would appreciate your help. I am kind of lost - I have taken Access 1 and 2 and am still trying to figure this all out.
Here is the scenario -
I have a database with customers contact information and details - HOMEOWNERS DATABASE.
I also have a different table specifically for those who have suffered damage from SANDY - SANDY DATABASE.
When someone calls to report sandy damage I want to enter it into SANDY- if they are already a customer I want it to reflect in the HOMEOWNERS DATABASE.
Also - the information that is already in SANDY - is there anyway to show a connection here?
Is this possible - what would be the best way to indicate that a customer has suffered damage from SANDY?
Thank you so much!!! I hope to one day be able to answer someone elses question. Thanks!