To grid or not to grid?

[jhermiz]

Im at a point in my vb where im lacking some serious
knowledge even with all these books. Im creating
a vb database application. To keep it short and sweet
without going into the details I have a table of
proposals each proposal can have many transports (one
to many relationship) BUT each transport could have
many transport components. Another one to many relationship.
So the structure looks like so:

Proposals
ProposalID (Primary Key)
Description
...
...

Transports
TransportID (Primary Key)
ProposalID (Foreign Key)
...
...

TransportComponents
ComponentID (Primary Key)
TransportID (Foreign Key)
...
....


Now I have created a form and split it up into some tabs.
The first tab is for general proposal information.
I have created this one and used ADO and SPROCS to send my
data etc. Now I need to start my second tab..the transports
data. But I dont know what to use since this is a one to many
relationship. Should I use a grid? Im not too familiar with
the workings of it. Because I need to add transports to a
proposal. BUT the problem is a transports needs to have components
so I kind of want the user to be able to see the transport info
and a listing of all the componneents for that transport. If
anyone is familiar with access i would like it to look like
a subform of transports and within that subform a datasheet
view or continous form of transport components. Is this possible
in vb? I know there is no sub forms in vb but how can I mimic this?
Can anyone please send any small examples please!!!!

Thanks,
Jon

[Muddy]

what is SPROCS?

You could populate the grid with a rst whose query string uses JOIN based on a user selection.

[jhermiz]

SPROCS are stored procedures in SQL Server...same as what you're talking about regarding returning a record set.
The main intent of SPROCS is usability and work is done on the server side rather than the client.

So is my transport just text fields and my components in some sort of grid ?

Jon

[Joffies]

You could use the msflexgrid or a data grid!

[jhermiz]

Can I have a combo box in an msflex grid?

Would it be ok to use a list view? I found an example of that?

Anyone out there with small examples using the msflex grid?

Thanks,
Jon