When you find yourself dealing with relational investigation (relevant data that is stored in separate dining tables), your often must see multiple tables or questions to the exact same mode. Such, you might pick consumer study from desk and details about customer sales off another table meanwhile. Subforms is a handy tool for doing this, and you will Availableness will bring multiple an approach to help you produce subforms quickly.
Know about subforms
An effective subform try a type which is registered an additional setting. The key means is named part of the setting, while the mode that is enclosed in shape is called the latest subform. A form/subform consolidation is commonly described as a good hierarchical means, a king/detail setting, otherwise a pops/kid form.
Subforms are especially active when you need to exhibit investigation of tables otherwise concerns with a single-to-of numerous dating. A one-to-of several relationship is a connection ranging from one or two tables where the no. 1 trick value of for every single record however dining table corresponds into value on the coordinating occupation or areas of many ideas on relevant dining table. Including, you possibly can make a form that shows employee data, possesses an effective subform that displays for every single employee’s instructions. The information and knowledge on Group table is the «one» area of the relationship. The knowledge from the Instructions dining table ‘s the «many» area of the relationship – for every single personnel can have one or more order.
An element of the mode and subform in this particular function are linked and so the subform screens merely info which can be relevant to the current list however mode. Such as, in the event that fundamental mode screens Nancy Freehafer’s information, the brand new subform screens simply the lady requests. Should your function and you can subform was indeed unlinked, the latest subform do display all the purchases, not simply Nancy’s.
What exactly do you should do?
The next dining table defines a number of the conditions that’s related having subforms. Availability will manage all of the info by using the fresh new measures in this post, but it is useful to know very well what is happening at the rear of the fresh views if you need to make changes later.
The handle you to embeds an application into a form. You might consider the subform control given that good «view» of some other object on your own database, be it other form, a table, otherwise a query. This new subform control provides characteristics which allow you to definitely connect the fresh new study demonstrated on manage on the investigation towards the chief form.
A straightforward screen of data within the rows and columns, like an excellent spreadsheet. The new subform manage displays a great datasheet whenever its supply object try a table or ask, otherwise when the provider object is a form whose Default Glance at house is set to Datasheet. In these instances, the subform might be also known as a beneficial datasheet or subdatasheet in place of since an excellent subform.
The property of one’s subform handle you to definitely specifies and this career or industries throughout the subform hook new subform on fundamental setting.
The home of your subform handle that specifies and this job or industries into head mode connect the main function to the subform.
To own the greatest results, expose dining table dating in advance of following steps on this page. This enables Entry to instantly create the hyperlinks between subforms and you may chief variations. To get into, put, otherwise modify relationship within tables on your database, with the Databases Systems loss, on the Inform you/Mask class, simply click Dating.
When an excellent subform control enjoys a questionnaire as its origin target, it has brand new areas that you place on the form, and it will be viewed due to the fact an individual means, continuing mode, otherwise datasheet. That advantageous asset of basing a good subform towards an application object try that you can include computed sphere towards subform, such as [Quantity] * [Device rate].
Deja una respuesta