Can I display fields from different records in one window in a for

[Guest]

I have a table that has the fields group number, serial number, and weight.
There are four weights in each group, and each weight has its own serial
number.
The table might look like this:
Group s\n weight
1 1234 10
1 1235 9
1 1236 11
1 1237 12
2 1238 10
2 1239 13
etc...

Each group has four weights and serial numbers associated with it.
I would like to enter weight data using a form where I can see the serial
number next to the weight I am entering. That is fairly simple, however, if
it is possible I would like to be able to enter all of the four weights from
one group in a single window. There are always four weights in each group.

Any help on this would be much appreciated.
Thanks,
Adam

 

[Guest]

Here is a little more clarification of the question:

I would like the form created to be in a format similar to this...

Group #___
Serial Number 1 _______ Weight 1 ________
Serial Number 2_______ Weight 2_________
Serial Number 3________ Weight 3_________
Serial Number 4________ Weight 4_________

I hope that clears things up a little bit. The words "Serial Number" and
"Weight" do not actually have to be there. The problem I have is that each
pair of Serial Number and Weight is a different record. It is very simple to
have the information displayed this way in a report using grouping levels. I
don't think that there is a way to create grouping levels in a form though.
I would appreciate any ideas on how to get this to work.
Thanks.

 

[Ron2006]

Here is a thought.

In general we are saying that the two tables are normalized and when
you look at the Group record you can pull in all four of the records
for the second table.

If when you create those four records you ALSO have an identifier in
each record that says that this is the A record, and B record, etc.

Then you could create a query that was a self union query,

The second table would be in the design part 4 times, The group number
of the first would be linked to the group number of each of the other 3
occurances, and then you would drop each of the three fields (record
type, serial number, weight) onto the design grid but put a criteria on
the first for record type A and the second for record type B etc.
Have criteria on the group number of the first be the group number of
the master table.
That would have all 4 records appear to you as a single record.



Before you develop the form however, create the query and then see if
it will allow you to update the fields. I do NOT believe you could add
records on this type of query, but you could get around that by having
a create button to add the necessary records - probably from a
different form.

Just an idea.............. and if it doesn't work it may trigger an
idea that will work.

Ron