Alternative to Table within a Table are ??

[Will]

When displaying a Order Form for Order Entry we want to display...

The fields in the Order Record

and...

Each associated Order_Item record (each line item for the order)

Is there a way to do this other than using the "Form within a Form" feature
in Access?

Thanks for the help.

 

[Dean]

If your tables are related, then on Access 2000 and newer, you can do
it in a table view. However, you can view one main table and one sub
table at a time. In a form, you can create tabs and use several sub
tables.

You an also use sub reports from main reports as well.

 

[Albert D.Kallal]

Is there a way to do this other than using the "Form within a Form"

feature in Access?

Hum, how you do his is much up to your imagination. You can use two separate
forms.

Another approach is to use two sub forms side by side.

For example, the left side could show many orders, and as you navigate, the
right side would show the details.

I have some screen shots of this conept here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Really, most of this is up to your imagination as to how you want to display
this.

Perhaps you seen some other application, or approach to this that you like?
You might want to take a look at Money, or QuickBooks, as those types of
applications are full of good ideas....

I should point out that a form+sub-form is often used in ms-access since
then you don't have to write a lot of code. If you use two separate forms,
then you have to write additional code to "sync" or "update" the "details"
form as you move through the main form (but, most development environments
require you to do this).

So, no, you don't have to use a sub-form, and you can come up with just
about any kind of interface you please...it is just going to depend on how
much effort and time you want to expend on this...

How the results look is rather much a issue of your own personal taste...