Newbie: Missing the link between Order Entry in a form and the actual Order Details

B

Bryan Anderson

I'm starting a new project and think I have the table design aspect figured
out with respect to "normalization" and can see how it relates to the
Northwind example database.

The problem I'm having is with respect to forms I can see what I want to
do from this example, but don't know of the term or concept that applies.

In Northwind, in the "Orders" form, they manage to tie multiple products to
a single order id. In the corresponding "Order Details" table, there are
multiple entries for the order id with the corresponding product (which I
understand).

The problem I'm having is, what is the term for doing this in form (ie. how
to create multiple table entries from a single order id). Is this what
they call a "sub-form".

Hopefully all this babbling makes sense. Just trying to figure out what the
terminology is so that I can research/apply it to my own application.

Thanks in advance for any assistance you can provide.

Regards,

Bryan Anderson
 
J

John Vinson

The problem I'm having is, what is the term for doing this in form (ie. how
to create multiple table entries from a single order id). Is this what
they call a "sub-form".

A Subform is a tool to handle just this case.

Using the Northwind example, the OrderID is the Primary Key of the
Orders table, and a "foreign key" of the OrderDetails table. You would
create a Form based on Orders, and a Subform based on OrderDetails,
using OrderID as the Master and Child Link Field properties of the
subform (Access will do this automatically if you've set up a
relationship between the tables and use the Form wizard).

With the Master/Child Link Field setup, the Subform will display only
those records related to the currently displayed mainform record; any
new OrderDetail records you add will inherit the current OrderID.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top