Hi,
I'm in my fifth attempt at designing a database, and I'm really frustrated. My issue is that I can't quite get a solid understanding of how I should set up my table relationships. The overall goal here is to create a form that will allow a user to enter basic quantity information, select a part, and view calculated prfoit margins on the fly. This form will also (I hope) allow additions to the part database. I'm not asking about the queries and the form design here - most of my progress so far is in this area, I just need help with the table relationships.
I have:
TblCustomerData
CompanyName
ContactFirstName
ContactLastName
CompanyorDepartment
BillingAddress
City
StateorProvince
PostalCode
Country/Region
ContactTitle
PhoneNumber
Extension
FaxNumber
EmailAddress
Notes
TblItemMaster
PartID
PartNumber
PartDesc1
PartDesc2
ItemFOBCost
ItemDDPCost
ItemAddlCost
TblVendorData
VendorID
VendorName
VendorAddy
VendorCity
VendorStateorRegion
VendorPostal
VendorPhone
VendorFax
VendorPort1
VendorPort2
VendorPort3
These tables are created, but have no data as yet. The initial field in each table is a primary key/autonumber field. I need to have multiple products associated with each vendor, and multiple products associated with each customer.
Can anyone tell me how to handle the relationships for these? Any suggestions on perhaps splitting out information into other tables? This is by far the hardest part of the process for me - anything anyone could offer is most welcome and appreciated.
Regards,
Ned
I'm in my fifth attempt at designing a database, and I'm really frustrated. My issue is that I can't quite get a solid understanding of how I should set up my table relationships. The overall goal here is to create a form that will allow a user to enter basic quantity information, select a part, and view calculated prfoit margins on the fly. This form will also (I hope) allow additions to the part database. I'm not asking about the queries and the form design here - most of my progress so far is in this area, I just need help with the table relationships.
I have:
TblCustomerData
CompanyName
ContactFirstName
ContactLastName
CompanyorDepartment
BillingAddress
City
StateorProvince
PostalCode
Country/Region
ContactTitle
PhoneNumber
Extension
FaxNumber
EmailAddress
Notes
TblItemMaster
PartID
PartNumber
PartDesc1
PartDesc2
ItemFOBCost
ItemDDPCost
ItemAddlCost
TblVendorData
VendorID
VendorName
VendorAddy
VendorCity
VendorStateorRegion
VendorPostal
VendorPhone
VendorFax
VendorPort1
VendorPort2
VendorPort3
These tables are created, but have no data as yet. The initial field in each table is a primary key/autonumber field. I need to have multiple products associated with each vendor, and multiple products associated with each customer.
Can anyone tell me how to handle the relationships for these? Any suggestions on perhaps splitting out information into other tables? This is by far the hardest part of the process for me - anything anyone could offer is most welcome and appreciated.
Regards,
Ned