Updating field info between two tables

[shaun_za]

Hi Everyone

I am trying to find out if the following is possible, and if so, how to get by it:

My father tables contains all the relevant fields with info of my products (which are listed in records/rows). My sister table contains less fields but are all present in the father table. The info is imported from excel daily into the sister table - all the fields here change regularly except for the unique ID which is present in both tables. Because the sister tables' information for the records/rows changes, it is difficult to update the selected fields of the father table.

Summarized, I want to update selected fields within my father table based on the information I upload from the excel sheet (which becomes the sister table when uploaded)

I hope I explained this well enough. Any help would be greatly appreciated.

[ranman256]

you must build an UPDATE QUERY.
this query has both tables in it, the Father, and sister. Join the 2 tables together on the common field key (or index) ID.
(these match dont they?)

in the query grid, pull down the fields from Father table on to the grid,
in the row UPDATE TO, set this to Sister table fields tSister.Birthday or whatever.

run the query to update all values all records.