Junction Table Sub-form (1 Viewer)

[tmyers]

I am trying to make a query or something for a sub-form that is bound to a junction table.

The general concept is data is entered into [tblFixtureTypes] with all the various designations for a light fixture (A, B ,C etc). Then later down the line, data is entered into [tblDrawings] (the specific page number of a blue print). On my sub-form, I have a datasheet that only has two fields. TypeID and Quantity from [tblDrawingFixtureType]. TypeID is currently a combo that is populated with all the data from [tblFixtureTypes].

My current version has the user select a type from the combo, then enter a quantity for it. The users don't like that. They want ALL types from [tblFixtureTypes] to be displayed in the datasheet and then enter a quantity for it. I do not know how I could accomplish that, since this sub-form is bound to that junction table and no data exist until a type and quantity is entered.

How could I change the form to display all the [TypeName] for this job and allow the users to enter quantities for them?

 

[MajP]

It sounds like you want a "checklist" where you see all the choices and do an insert or delete query on the selected choice. There are many examples here.
This is one example but I would search for more on this site.

Solved - Three-part form

I am working on a form which is going to be based on three tables. It is logging incidents reported so first table has general details (date/time), second table flags incident as specific categories - can be multiple, and third table records details of person involved - also may be more than...

www.access-programmers.co.uk

Post 5 on that thread is a somewhat generic version. The thread gets a little involved because it deals with multiple "checklists". I do not know if there is an official term for this concept I just call the concept "checklist"

 

[CJ_London]

you could try left joining fixture types to drawingfixture type. and in the form before update event assign the drawingid to the value in the parent form. You will probably need to remove the linkchild/master properties from the subform control