Help with append query for one-to-many relationship tables

[Vika]

Hello

Can anyone help me with this problem? I need to append a flat table t
two tables. I have two tables Observations and ObservationsB that ar
set up to one-to-many relationship, and one FlatTable that has al
the data that I need to append to tables Observations an
ObservationsB.

Table Observations
Table Observations
Table FlatTabl
ObservationNumbe
Transec
Statio
Tim
EndTim
ObsCod
Dat
Clou
Rai
Win
Gus
P
P
P
P
P
P
P
P
P
P1
Comment

Table ObservationsB
ObservationBNumbe
ObservationNumbe
AlphaCod
Distanc
Detectio

Table FlatFile
Transec
Statio
Tim
EndTim
ObsCod
Dat
Clou
Rai
Win
Gus
P
P
P
P
P
P
P
P
P
P1
AlphaCod
Distanc
Detectio
Comment

From table FlatFile I need to append fields: Transect, Station, Time
EndTime, ObsCode, Date, Cloud, Rain, Wind, Gust, P1, P2, P3, P4, P5
P6, P7, P8, P9, P10, Comments to table Observations and fields
AlphaCode, Distance, and Detection to table ObservationsB.

I have an append query that appends records from FlatTable to tabl
Observations without any problem. When I create and run append quer
to append records from FlatTable to ObservationsB I get an erro
message and not able to append. The problem comes that two table
Observations and ObservationsB are set up to one-to-man
relationships. For example, Station from table Observations has 1
AlphaCode from table ObservationsB.

Is there any way I can append data from FlatTable to table
Observations and ObservationsB? I would really appreciate any hel
and ideas


Thank yo

 

[SteveS]

Hello,

Can anyone help me with this problem? I need to append a flat table to
two tables. I have two tables Observations and ObservationsB that are
set up to one-to-many relationship, and one FlatTable that has all
the data that I need to append to tables Observations and
ObservationsB.

Table Observations:
Table ObservationsB
Table FlatTable
ObservationNumber
Transect
Station
Time
EndTime
ObsCode
Date
Cloud
Rain
Wind
Gust
P1
P2
P3
P4
P5
P6
P7
P8
P9
P10
Comments

Table ObservationsB:
ObservationBNumber
ObservationNumber
AlphaCode
Distance
Detection

Table FlatFile:
Transect
Station
Time
EndTime
ObsCode
Date
Cloud
Rain
Wind
Gust
P1
P2
P3
P4
P5
P6
P7
P8
P9
P10
AlphaCode
Distance
Detection
Comments


From table FlatFile I need to append fields: Transect, Station, Time,
EndTime, ObsCode, Date, Cloud, Rain, Wind, Gust, P1, P2, P3, P4, P5,
P6, P7, P8, P9, P10, Comments to table Observations and fields:
AlphaCode, Distance, and Detection to table ObservationsB.

I have an append query that appends records from FlatTable to table
Observations without any problem. When I create and run append query
to append records from FlatTable to ObservationsB I get an error
message and not able to append. The problem comes that two tables
Observations and ObservationsB are set up to one-to-many
relationships. For example, Station from table Observations has 10
AlphaCode from table ObservationsB.

Is there any way I can append data from FlatTable to tables
Observations and ObservationsB? I would really appreciate any help
and ideas.



Thank you

See your previous posting from today @ 9:50AM....