Topic: Saving data to 2 tables
Hi,
I have a project that has a table that records the locations of a trip (Tripnum, Country, Location) and I want to have another table that is a summary of the first in recording Country, Location and the number of visits. Is this possible and if so can the summary table feed of the first. Meaning as the data is saved in the first table the second is added at the same time ie before or after saving. Thanks for any help
Terry