Nested Subforms - Intermediate Table



I have an Inventory database. We want to take a bill of Materials/Parts List, and match it up against our Inventory table, and issue parts to fulfillthe lines on the parts list. SO-

Table 1- JobDetail (Partno, Desc, Qty, QtyFilled, Sect, SubSect)

Table 2- JDPtrBL (Partno, Sect, Subsect, BinRow, BinShelf, Bin, Pref)
<----------- ----------->
This side points up These point down to the
at the detail Line Binlocation Table

Table 3- BinLocation (Partno, OnHand, BinRow, BinShelf, Bin)

Hope this makes some sense, and it's still in a proportionally spaced font!

What I'm trying to make then is a form that will allow me to go down the JobDetail, and Update any Attached Binlocation OnHand Values they find. I don't even need to see the JDPtrBL table, Because the edits the user will do are either to the JobDetail QtyFilled, or to the Binlocation OnHand.

This idea I had of linking the Many-to-Many records in the JobDetail and inBinlocation using a pointer file to say which Binlocations attach to whichdetail line seemed like a great idea at the time, Except Multiple nested subforms don't seem to do the trick.

Am I missing something? The first form for JobDetail won't let me set continuous forms, but even if I had to have the user scroll through them one byone, the two nested subforms for JDptrBL into BinLocation seem very unwieldy, and no matter how I format them they don't seem to work right.

Anyone have any ideas?

Thanks in advance! You guys always have pulled my Programming Bacon out ofthe fire multiples of times!!



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question