Data duplication may make your SELECT queries easier to write, but you can very easily end up with data integrity issues. FROM Tickets INNER JOIN Ticket Templates ON Tickets.
So when might you need to copy data from one table to another?
Sample Database: Linking Two (26K) Microsoft Access makes it easy to see related records on forms.
A simple Access form has a record source displaying data from a table or query.
In the sample database, the form frm Simple shows an example where the form's recordsource is the master table (tbl Master) and the subform (sub Detail) displays its corresponding records: The subform only displays the records for one value in the Master ID field.
The form can be displayed in: One of the most powerful features of displaying data is the use of subforms.
A subform is a form with its own data source that is embedded in another "master" form.
Subforms provide a powerful way to easily see related data, especially one-to-many relationships, without writing code.
Access automatically filters the data in the subform based on data in the master form.