In these situations, you'll want to set up and use a multitable form for data entry.
For example, Figure A shows a multitable form included with Access' sample Northwind database.
If you didn't use a multitable form, you'd have to display a different screen for each combination of company name, order, and order detail.
The most common way this is done is by creating linked tables in Office Access that use the SQL Server ODBC driver to connect to tables in SQL Server databases.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. When you choose a different customer, different data appears in the lower two forms.When you choose a different record in the middle form, the bottom form displays data specific to that selected record.