We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
他のテーブルのデータ
別のテーブルからデータ
In contrast, a lookup list takes its data from a lookup field (a field that uses a query to retrieve data from another table), and then loads that data into a combo box control.
You can create two kinds of lookup fields- table-based lists and value lists. A table-based list uses a query to retrieve data from another table, and a value list displays a set of hard-coded values. The following procedure explains how to create both types of lists.
By default, list box and combo box controls display two types of lists: value lists and lookup lists. A value list is a hard-coded list of items that resides in the Row Source property of a list box or combo box control. In contrast, a lookup list takes its data from a lookup field (a field that uses a query to retrieve data from another table), and then loads that data into a combo box control.
If you require a form that can refer to the data in a table or query and can additionally display data from another table, you should create a sub-form.
You may have cases in which a query that is based on one table gives you the information you need, but pulling data from another table would help to make the query results even clearer and more useful.
You may have cases in which a query that is based on one table gives you the information you need, but pulling data from another table would help to make the query results even clearer and more useful. For example, suppose you have a list of employee IDs that appear in your query results. You realize it would be more useful to view the employee name in the results, but the employee names are located in a different table. To get the employee names to appear in your query results, you need to include both tables in your query.
必要な情報が 1 つのテーブルに基づくクエリで得られる場合もありますが、別のテーブルからデータを取得することで、クエリの結果をより明確にしたり、便利にしたりできます。たとえば、クエリの結果として得られる従業員 ID の一覧があります。この結果に従業員の名前を表示するとさらに便利ですが、従業員の名前は別のテーブルにあります。このような場合、クエリの結果に従業員を表示するには、クエリに両方のテーブルを含める必要があります。
Potentieel gevoelige of ongepaste informatie
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.