I have created a data base with 3 tables. The first table has only 2 records and each record is linked to many in table 2.
I have used a form sub form to eneter table 2 data without problems. I just select the name of the record in table 1, and enter everything else in table two. In table two I have used a lookup to table one for the name in table one. This worked and the datasheet in table 2 showed many instances where each of the two names apeared with different equipment atrributed to each one!
For table 3 i wanted to list tasks to be done with each peice of equipment. Say there are 2 cars in table 2, Car 1 for Rob and Car 2 for steve.
I have used the same process, look up fields for Name, and Equipment (looked up from table 2) and created a form/subform where those 2 fields apear on the form, and task details on the sub form.
I have two issues. After entering a heap of data into the sub field under diferent combinations from my query I checked the data sheet for table 3 and noticed the equipment colum was empty.
I also noticed in this view I could enter data using the lookup, but it didnt mater if i had the wrong car with the wrong person. That combination was not a record in table 2.
What have i done wrong?