Access Form to control Data Entry
Posted on 2009-04-30
I am trying to develop a data entry only form for Microsoft Access 2003. I want the user to use a combo-box to select the Vendor, then it should display details about the vendor and display a Product combo-box filtered to the Vendor selected. Selecting the Product should display Product information. Then the user inputs details about the Product, ie. Serial No., Exp Date, etc.
This is a portion of my Database Structure (I am not sure if the Primary Key or Foreign Key relationship is right):
VendorID pk (1:many to tbl_Products.SupplierID)
ProductID pk (1:many to tbl_ImplantDetail.ProductID)
SupplierID fk (many:1 to tbl_Vendors.VendorID)
ControlID pk (1:1 for expansion and additional data collection)
ProductID fk (many:1 to tblProducts.ProductID)
LocationCD fk (many:1 to tbl_Location.LocCD)
LocCD pk (1:many to tbl_ImplantDetail.LocationCD)
I understand that Visual Studio 2005 might be better to use, but I have only just started to practice with it.
Thanks for any help you can give.