I want to make a database to gather information about commercial aberrations our company gives to our clients.
I have made a table Tbl Aberration with an ID, Opening date (of the aberration) and closing date and want now to add the type of aberration. Since these types may changes in the future it's better to make a different table with calling f.e. Tbl type. And then of course also a table with the clients names, addresses, etc..
How do I make the link between the tables and how do I than f.e. make a form which gives me per client a list of the type and their opening and closing date...??