how can store one record wif multiple rows of data

Hello!

I am using visual basic 6 and MS Access 2000.
Wat should i use? datagrid,flexgrid or hierarchy flexgrid or other controls?

How can put so that one record can have multiple rows of data?

| Record| Cell|
------------------
| Abc | rst |
------| cnn |
------| nmo|
------| plo |
| DEF | xxx |
------| xxx |
------------------

Thanks for reading my post.

a question. How many records is it necessary that you show at one time. Is this like a single customer/multiple orders situation where you might want to show all orders that a single customer might have placed, thus producing 5 or six rows?

max of 9 data row...

whatever control you use, it would have to be filled programatically instead of setting the datasource member equal to a recordset and with that said, it really doesn't matter what control you use since it will be use controlling each column/field to be filled.

U should use relation database..
Microsoft Access - Relational Database Example
This example shows step by step how to create 2 relational tables and create a form and sub-form to display those results. It's one of the basics of access that must be understood if you want to create any kind of database. Once you have done this and understand it you will be writing creative databases in no time.

The example shown here was for a radio ham who wanted to store details of contacts and history.

Imagine Hams contains a list of hams with fields HamID HamName HamLocation

HamID should be set as your unique ID. I.E 2 'Hams' may have the same name but never the same HamID
ContactHistory contains contact history with other hams with fields AutoNum HamID Date Details
Autonum is your UniqueID and we don't really care about it or use it for anything
Here is that database with the tables set up and some data.

a relation access DB sample

Plz visit for more http://www.fabalou.com/Access/General/relational.asp

Thanks

Everyone who has reply to my post.

:thumbs up: