Have multiple boxes on a form depending on items in tables/query

[Lensmeister]

Morning all,

It's been a very long time since I have done anything in Access and despite googling I cannot see the answer I need, so I hope someone can help with this.

I have two tables (mydb and tbl_Repairs) that I need to use to produce a form of.

In tbl_mydb and tbl_Repairs I have field (loconumber) that at linked in relationships as 'indeterminate'. (Also I have a Query (qry_gbstock) that I would prefer to use instead of tbl_mydb.)

In tbl_Repairs there can be several instances of the loconumber in that field i.e.
loconumber can have:
47567 next field 'repair' could have 3 different record for that one.
47467


What I need to make is a form that shows the field
loconumber (and other fields I need) plus the 'Repair' field from tbl_Repairs with all the instances of items in that field.

Hope this makes sense.

(Cannot upload an edited copy of the mdb at this time but will tonight)

 

[plog]

Hope this makes sense.

Not really. Can you demonstrate your issue with sample data?

With that said, a form that interacts with data (add/edit/delete) should be based on just one table, not a query. When you need to work with data from 2 tables that are in a 1 to many relationship you create a main form and subform. The main form is based on the 1 table and the subform is based on the many table.