Re: Create new records based on a query list?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Larry
You have understood the required process precisely.
The table structures are pretty much as I anticipated and are all up and
running.
My uncertainty is at the last point where I need to populate a new record
for each test point in tblTestPointReading. I can't see how to create and
fill in these records.

Thanks for the help

John

"Larry Daugherty" <Larry.NoSpam.Daugherty@xxxxxxxxxxx> wrote in message
news:uz94YQoNGHA.964@xxxxxxxxxxxxxxxxxxxxxxx
From what you've given I see two tables; tblEquipment and tblTestPoint
which should be related with Referential Integrity on. I suggest
adding another table, tblTestPointReading. TPR would be the many side
of one-to many with tblTestPoint with Referential Integrity on.

tblTestPointReading would have fields for TPRID, TestPooointID,
TestPointName, ReadingDate, maybe ReadingTime, TestPointValue.
TestPointNote.

Your main form for taking readings would be based on a piece of
equipment. Once the equipment is selected, its subform (based on
tblTestPointReading) would be populated with a new record named for
each test point for which a reading will be taken.

HTH
--
-Larry-
--

"John Milward" <john.milward@xxxxxxxxxx> wrote in message
news:dtcv36$sd5$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a database with Equipment, and related test point tables.
When i pick an equipment item there are a number of related test
points
found.
All fine so far.
I need to show this list of points along with an additional box
where the
user types the result of each test point.
When complete they need to click a button which will create, in an
additional table, a set of records (one for each point) that store
this
information.

Can someone point me in the best direction to solve this please?






.

Quantcast