M
Mike B
I have a very early database I built that I am now trying to up-date. When
I built this database I create the main table (tblPartnumber) with a ID
field, so it has a unique ID (no dups). The sub-table (tblPriceDetail) that
stores the prices by date does have a ID but not one that matches (the ID
field can be duplicated and is autonumber). The two table are related by
the "partno" field. Not a good design but at the time I did not no any
better. Learned a lot in between.
What I have done is create a new field in the tblPriceDetail table called
IDPrice. I want both the tblPartnumber (ID field) and tblPriceDetail
(IDPrice field) to have the same number. One way is manually but the table
is 6000 records.
Is there a way to run an UpDate Query (or something) to copy to
tblPartnumber field ID to the tblPriceDetail field IDPrice?
Thanks in advance for the help,
Mike B.
I built this database I create the main table (tblPartnumber) with a ID
field, so it has a unique ID (no dups). The sub-table (tblPriceDetail) that
stores the prices by date does have a ID but not one that matches (the ID
field can be duplicated and is autonumber). The two table are related by
the "partno" field. Not a good design but at the time I did not no any
better. Learned a lot in between.
What I have done is create a new field in the tblPriceDetail table called
IDPrice. I want both the tblPartnumber (ID field) and tblPriceDetail
(IDPrice field) to have the same number. One way is manually but the table
is 6000 records.
Is there a way to run an UpDate Query (or something) to copy to
tblPartnumber field ID to the tblPriceDetail field IDPrice?
Thanks in advance for the help,
Mike B.