Search results

thank you for your response. to answer your quest, yes! I can do whatever I want with the tables :) I am, for all intents and purposes, the database admin on this project. Knowing that the way that I'm doing it is the correct way is the biggest issue for me. So would you setup a different...

I'm building a product Information Database. As part of the product data, I am required to indicate the master case used to package the product. tblProductInfo - ProductID - ProdcutDesc - MasterCase (FK to tblMasterCase) tblMasterCase - MasterCaseID - MasterCaseDesc -...

Head First SQL just arrived today, Excited to start getting a real handle on some of this stuff.

I'm currently working on trying to set it up as suggested by beetle. I think he's pointed me in a good direction. I'll post back if I run into more road blocks. On a side note, I've really appreciated the help and support of the access community. you guys have been awesome. I'm always...

Good point Bob, Thanks again :)

Thanks for your response beetle, I was able to edit the records using the first sql I had that contained all 3 tables, it seems like i should be able to set it up the same way using this other sql, but maybe not. I'll play with it some more and see what I can find out. Thanks!

I'm designing a form that will allow users to interact with 3 tables constructed together with a Many to Many relationship: tblProductInfo tblPackaging tblProductPackagingMM I've setup all the relationships as they need to be and I'm in the process of designing the querries / forms. I'm...

Apparently I posted 5 minutes too soon. I discovered the issue was in my sql querry, I hadn't included the ProductIDFK field. After I did that the problem seemed to resolve itself. Thank you, and sorry for the post :)

I have 3 tables tblProductInfo - ProductID - ProductItemNumber - JDEDescription tblFacility - FacilityID - FacilityDescription tblProductFacilityMM - ProductToFacilityID - ProductIDFK (combined with FacilityIDFK to make a PK) - FacilityIDFK As I'm writing this out, I am realizing that...

...um... thanks?

I have been working with databases for the last 6 months or so. I am entirely self taught. Starting this fall I have the opportunity to attend school to recieve a more complete education so that I can increase my effectiveness as a DBA. I'm interested in attending school so that I can...

Perfect! That did Exactly what I was looking for, thanks! :)

I should clarify, I have 3 tables setup, but I am still able to create duplicate instaces of the same Author - book combination for some reason. I included a copy of the database in my original post if it helps to see it. Thanks!

I'm learning how to do Many to Many relationships and I think I've got the basic idea down, I am just not sure how to prevent the same 2 records from being associated twice. For example: My practice database deals with Authors and Books. I was able to set it up so that Mike Gunderloy...

I'd love especially if there are any online courses for this (free or paid). Thanks!

I have just started to get my toes wet with VBA and I'm finding as my needs for VBA get more complicated, so does my need for a more comprehsnive understanding of it. Does anyone have a resource they like for learning principles of VBA? I'd like to start pretty basic if possible and work my...

I'm trying to run a querry between 3 tables: tlbProductInfo - ProductID - PK - ItemNumber - JDEDescription - FilmTopID - FK to tblPackaging - RetailCaseID - FK to tblPackaging - MasterCaseID - FK to tblPackaging tblPackaging - PackageID - PK - JDEPackageID - PackageDesc - Packagetype - (used...

I'm trying to run an update query to change the last used date for all products on tomorrow's production report to tomorrow. I would like to be able to type or copy/paste each item number from the schedule into a querry to update them quickly, but I'm running into some problems. This is what I...

- There are 4-6 different bacterias tested depending on the invoice, but they are always a selection of those 6 - The allergens are always 1-3 from the selection of 3 - the Integrity tests are always a selection of about 4-6 of 6 total A single allergen test result will include - swab# -...

Each invoice number would correspond with a single test set. for example: You would never have an allergen and an environmental or integrity test connected to the same invoice number. They will always be on different invoices. However - You would have a tests for Soy, Nuts and dairy...