As a novice access user I am trying to develop a database for waterpoints, communities and associated data. There are a large number of linked tables with referentially integral joins. This situation must be a very common one. What is the best way to enter data into such tables?
Attached is a...