Data in Query

[djkoon]

I need help
here is the data from table a

Coast_Id FNM_LN_ID LN_SPCL_FEAT_CD
1261 4000024502 3
1261 4000024502 175
1261 4000024502 402
1262 4000024501 3
1262 4000024501 135
1262 4000024501 402
1274 4000024446 3
1274 4000024446 122

Now I have to place this data in to table say B
like this

Coast_Id FNM_LN_ID
1261 4000024502
1262 4000024501
1274 4000024446

LN_SPCL_FEAT_CD1,LN_SPCL_FEAT_CD2,LN_SPCL_FEAT_CD3
3 175 402
3 135 402
3 222 000

there could be 20 record forn one Coast_id and then I have to place for on Coast_id 20 LN_SPCL_FEAT_CD ...

I try my best to explain the senario.
Hope fully you will help me better way now
all field are number type.

Thanks

 

[willir]

First, you should realize you have a one-to-many relationship...
LN_SPCL_FEAT_CD1,
LN_SPCL_FEAT_CD2,
LN_SPCL_FEAT_CD3

(You should consider only using LN_SPCL_FEAT_CD and create a new record for each new feature.)

Consider the following....
Fundamentals of Relational Database Design by Paul Litwin
Download document
Read on-line (HTML)


Micro$oft's answer...
Where to find information about designing a database in Microsoft Access
283878 - Description of the database normalization basics
304467 - ACC2000 Defining Relationships Between Tables in a Microsoft Access Database

Next, are you looking for a query to do this, or a data entry form? You have to enter the data anyway, so you may wish to use a form to enter the data as required.
A classic Main form and Subform is a very common approach.

Richard