Search results

I am having trouble using a form as input for a query. The form uses multi select list boxes, with then intention being that if I select multiple fields then only records which include those fields will show (not only fields that contain those and no others). I also have successfully worked up...

Sorry Bob, I'm not understanding your question. Was it posted in the correct thread?

This is the table simplified and recreated in Access 2003. My goal is to have the form that shows the many WN#s (materials) in the subform, also list the other fields that are part of that specific WN#, since none of these should show up twice on this form.

I see what you are saying after reading the article. Each individual material may be used in one or more batches. But this is not always known when receiving the material, which batch it will be used in. Is this the case where the batch number does not relate to the material's tracking...

I don't have a problem with rethinking the whole thing. I can scrap the non foreign keys from the junction table. I tried it this way first and attempted to create a query that pulls information from both the junction table and the materials table. Ideally if I had material A going into...

Sorry, I may have given an unclear description of what I was going for. I would like to not have to input the same information over and over again into the subtable for it to show up on the other form. I may have gone about this the wrong way. My idea was to have a many to many relationship...

If you go to tblzzCMRCompletionTracking, you will see the subtable when clicking on the + symbol next to record. The fields in the + part are the same as this table, but when filling in the information they do not populate with the same information. Does this make sense?

Yes, my effort is with the tbl B, where I would like all of the fields in the subtable to be populated with information from tbl A. In the first form I want to put the material information in, and then add the batches individually. Cheers, Mick

Here. The autopopulated tables may be doubled.

It will not allow me to do that. Looks like I am using something that was not in earlier formats. I'm sorry. I am using 2010. I have noticed I have many tables that are automatically populated when i make a new database, they include: MSysAccessStorage MSysAccessXML MSysACEs MSysComplexColumns...

Hello all, I've established a many to many relationship using a junction table. So I have 3 tables (A for "materials", B for "batches", and J for "junction") Form A is linked to table A, and contains a subtable linked to a query from table J. This allows me to input materials into table A and...