|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 16th, 2005, 09:47 PM
|
|||
|
|||
Help with append query for one-to-many relationship tables
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 
|
|
#2
September 17th, 2005, 08:29 AM
|
|||
|
|||
|
Vika wrote:
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.... -- Steve -------------------------------- "Veni, Vidi, Velcro" (I came, I saw, I stuck around.)
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
| Moving from xBase/Clipper | [email protected] | New Users | 1 | February 3rd, 2005 07:25 PM |
| append query doesn't work since can't recoqnize field | juan | Running & Setting Up Queries | 1 | February 1st, 2005 01:25 AM |
| Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
| Using an append query with an update query | Joshua Schairbaum | Running & Setting Up Queries | 1 | July 15th, 2004 02:22 AM |
Linear Mode
