Append Query Help

[perrymans]

I am importing information into a normalized structure. The original table is one table, being split into numerous others, but right now I am only concerned with two, tblHours and tblPaid.

Each record goes to tblHours with fields like HoursWorked and EmployeeID. I wanted to keep whether or not something was paid, and how much, separate (although it is a one-to-one relationship). My problem is that I run an Append query to insert the hours info into tblHours, which is then given an autonumber ID. Now, I can't figure out a way to put the AmountPaid and DatePaid into tblPaid, will keeping it associated to the tblHours records.

I tried appending all the records to tblPaid with no link, then going back with an Update query and trying it like that, but the fields won't update.

How would you complete such an Append?

Thanks. Sean.

 

[lespaul]

in your tblHours there's no date to indicate when the person worked those hours? or any other unique field other than the autonumber?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design