Continuous form in continuous form

[bvdahl]

Hello,

I know that the above mentioned is not possible in Access, but what do you
do if that is really what you need?

I have teo tables, lets call them truck and shipments. Each truck has
several shipments on them, so the two tables are related on the truck_id
field.

The guys running these trucks, need a screen wher it is easy to get an
overview of ehich trucks are at their disposal, and at the same time, which
shipments are on each truck. It is no good to look at one truck at a time,
because it is very easy to lose track of the big picture. At the same time,
it is imperative that they can see wher the trucks are going, so that they
can make desicions on where thay are going once they have offloaded
everything.

A listbox in the main form would work as well, but when I try that, all the
trucks seem to have the same shipments on them. I know the reason for this,
but if there is no way around, I am stuck big time.

Does anyone know how I can do this? I prefere a list box over a subform, but
any solution is acceptable as long as the screen shows what I have described
above.

thx

Baard

 

[kingston via AccessMonster.com]

Have you tried subdatasheets? This only works with Access 2000 and higher,
but if your users can work with a nested table format, this will allow you to
display a lot of related information in a compact format. So, open the main
table and use the menu item Insert to add a subdatasheet. The subdatasheet
will be the second table (or query) that shows the related records. Then
when you create a form based on the first table (or a query based on the
first table), display the results in datasheet format. A button will appear
to the left of each record with a + sign. Click on this button to expose or
hide the related data.

It sounds like you'll have a main form for the users to filter for trucks.
The results will be displayed in a subform datasheet (probably based on a
query). Then each record will have a subdatasheet based on shipments.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformInContinuousForm.mdb" which illustrates one way to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Albert D. Kallal]

Just put two sub-forms on a main form.

here some screen shots and ideas:

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

The very last screenshot shows "many" on the left side, and "many" on the
right side.....

 

[bvdahl]

Thanks Roger,

That seems to be exactly what I am looking for.

Baard

 

[bvdahl]

I was a little quick with the acceptance of Rogers solution, there.

Allthough it works perfectly, it does not really solve my problem,. I want
the user to be able to look at both the header and the subform date without
having to flick through the records. Idealy, it would look like this:

Truck Data
Shipment Data
Shipment Data
Truck Data
Shipment Data
Truck Data
Shipment Data
Shipment Data
Shipment Data

and so on.

Are you seeing what I am getting at?

Baard

 

[BruceM]

A report grouped by a TruckData field may provide what you are looking for,
if I understand correctly, although you be able only to view the data, not
interact with it.

 

[bvdahl]

Yes, thanks, but being able to enter som data is vital

Baard

 

[Albert D. Kallal]

yes, I do....

And, my suggestion was simply that you put the shipment data on the right
side of the form, and the track data on the left side...

 

[bvdahl]

Well, I see your solution, but if I am not mistaken, you still have to select
a record in the 'main' form to see the underlying records in the 'sub' form.

I need to be able to see the underlying records for all (or at least as many
as you can fit on the screen) the records in the main form simultaneously.

Baard

 

[Albert D. Kallal]

Well, I see your solution, but if I am not mistaken, you still have to
select
a record in the 'main' form to see the underlying records in the 'sub'
form.

You don't necessary need a main record in my example. That *last* screen
shot of the "classic" dispersing funds from a given cheque to multiple
accounts just "happens" to have a main record. The fact that this example
also has a "batch number" and date information at the top as the "main"
record is really moot.

if you look, what is impoartnat here is that the left side has a list of
Familes, and when you navatage this list, the right side dispays the details
records for the left side.

http://www.members.shaw.ca/AlbertKallal/Articles/grid2.gif

In the above, the left side shows calla as selected, cheque amount of $50,
and the right side shows the two detail records (that total up to $50).

As you navigate the left side, the right side shows the details......