Hi Deb,
I have uploaded JewelryInventory3cw.zip to your folder
in the 2_AssistanceNeeded folder.
There are several things to look at.
The Relationships have been changed.
1. the Parts_Inventory_Popup Table has been deleted and
replaced with a query.
2. Table Pieces_BOM has been added to show a possible
table structure.
3. Note that table Inventories_Pieces_Subform should be
deleted and replaced by a Query. If you have trouble
creating the query then let us know.
I have added two buttons to Main_Menu to show how the
the Pieces_BOM table can be used. Try them out.
4. Pieces: Shows the Pieces on the main form and the BOM
in the SubForm datasheet.
5. All_Pieces: Shows how to you can display more
information about the Parts and the BOM. It's a easy way
to see a lot of information. You can easily filter for
a particular field and see how many records match it.
You will probably notice that I have been changing the
size of forms. That's because I use a screen resolution
of 1152 x 864 to give me the best view. I find that higher
resolutions give a harder to read screen. I reckon that
you must have a 1600 x XXXX monitor.
I'm sorry this has taken so long but other work has been
keeping me busy.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Deb <beader59@...> wrote:
>
> Hi Clive,
>
> Thank you! I just uploaded my new DB to the files, it's under Deb - Help
> Needed. I am not able to enter any data into Inventory Pieces or Item
> Sales. Here is a breakdown on the DB and what I am wanting it to do.
>
>
> Parts Purchase
>
> The main form contains 1 record for each part
> The subform show each purchase of the individual part.
>
> Tab 2 - Inventory list of each part in stock
>
> Tab 3 - Part History - Shows what finished item each part was used in
>
>
> Inventory Pieces
>
> Main Form - Shows each inventory item made
> Subform - Shows each part used in making the item
>
> Subform 2 at bottom - Shows cost and sale price of each item made
>
> Item Sales
>
> Main form shows each item from Inventory Pieces
> Subform shows sale information for each individual item
>
> Tab 2 - Item Inventory shows an inventory of every item.
>
>
> The first section - Parts Purchase/Inventory seems to be working fine.
>
> Inventory Pieces worked until I added Item Sales and then it started not
> letting me add records.
>
> What I would like it to do, is to be able to enter an inventory part and
> have the information entered into the main form automatically fill in the
> main form on Item Sales. They are both bound to the Inventory Pieces
> table...
>
>
> Please let me know if you need more info, I'm not great at explaining
> things! ;-)
>
> Thank you!!
>
> Deb
>
>
> On Sat, Aug 20, 2011 at 5:15 PM, Clive <zctek@...> wrote:
>
> > Hi Deb,
> >
> > Thanks for the information.
> >
> > I think you probably need an Inventory_Pieces_BOM
> > (Bill Of Materials) table. For example, a Piece
> > might consist of:
> >
> > Part_Name, Quantity
> > ~~~~~~~~~, ~~~~~~~~
> > SmallBeads, 12
> > MediumBeads, 4
> > Clasp, 1
> >
> > in which case you need a Pieces_BOM table and the
> > relationship from Inventory_Pieces to Pieces_BOM
> > will be a One_to_Many instead of a One_to_One.
> >
> > The key to a good database design is the tables
> > and relationships between them.
> >
> > Before I make any more suggestions, could you
> > upload your current Db so that I can see your
> > latest structure?
> > It would help if it had more sample data in than
> > the previous Db.
> > Note: If you can't enter the data you want into
> > the tables then it is probably a problem with the
> > relationships.
> >
> > Regards, Clive.
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar