Sub Form Relationships

[Nick M via AccessMonster.com]

I currently have a form that links two queries. The first query simply
links a unit name with some other supporting information from a table. The
second query relates maintenance that is done to the unit. Since
maintenance can be performed multiple times on one unit I have set up a
table that has a 'maintenance number' along with the unit number, date,
type of work, etc...

The form shows everything well, but if I group my first query by unit
number, then I am not able to add new units from the form. For some reason
the program locks me out, but I can edit previous entries. If I don't use
the group by function then I have multiple entries for each unit.

The goal is to have one form entry for the unit number that allows for
multiple instances of maintenance in the sub form. I hope this is clear
enough, its kind of tough to explain well.

Thanks,

Nick M

 

[Nick M via AccessMonster.com]

One further thought.....I would love to be able to type in a unit number,
and if there is already information on that unit, see it all and be able to
add new, and if no old data, be able to start a new 'history' for that unit.