creation of subform

[Guest]

I have been fighting with this concept for a couple weeks and yesterday the
idea of a subform was suggested by you folks and think this will work...I am
not understanding how to allow or make room for the succeeding individual
testings in the testing table for each item.

A bakery with many many items...each has it's own record which is quite
extensive. Every six months each item gets tested for three indicators so I
want to pull out the date field and the three indicator fields for each
testing and put those in a related database using the autonumber primary key
from the master and an autogenerated key in the child table.

I have a master form for each item which I would insert a subform containing
the four fields for each testing for each item. I just want to keep track of
all the testing dates and results for each testing of each item and have them
display in the subform on the master form in chronological order. Can anyone
offer some guidence? Thanks

 

[Larry Daugherty]

Hi Jeff,

In the query for the subform choose the desired Sort on the Date field of
the tests.

HTH

 

[Guest]

I am still fighting the proper set up of my two tables.....at this point when
I built the child it relates one-2-one...I haven't been able to get the child
set up to accept additional records (test dates) which then become the many
of the one(bakery item) to many (tests) in the relationship. can you help?

 

[Larry Daugherty]

Hi Jeff,

Post back with your table names and their first 4 or 5 field names and data
types. I'm pretty sure that your data design is flawed. Don't despair,
it's fixable. How much data do you already have in any of your tables? "A
bakery with many many items...each has it's own record which is quite
extensive". It may be that we'll have to start with new table designs and
then deal with getting your data into the new tables.

HTH

 

[Guest]

Hey Larry:

I continued this problem this morning under another heading: "Redefine
Index??"

The Bakery was an example....if you have time for the problem I thnk the
posts on the other heading will clue you in. I am still fighting it. Thank
You..I appreciate you.