Hey everyone! I'm currently studying access 2003 at school. I've came across a major stumbling block, in the current database we're studying, everyone is confused as well as the teacher, which is concerning.
We are given data, about customers, phone makes, and contracts. I've made 4 tables, CustomerTBL, ContractTBL, CustomerContractTBL, and PhoneTBL.
Primary Keys are: CustomerID, ContractID, and PhoneID.
The problem is, we're meant to create a form, and the purpose of this form, is to add contracts for new customers, and existing customers.
I'm confused how i go about this, so is my teacher, which again is concerning. Any suggestions?
Thanks in advance for any replies.
We are given data, about customers, phone makes, and contracts. I've made 4 tables, CustomerTBL, ContractTBL, CustomerContractTBL, and PhoneTBL.
Primary Keys are: CustomerID, ContractID, and PhoneID.
The problem is, we're meant to create a form, and the purpose of this form, is to add contracts for new customers, and existing customers.
I'm confused how i go about this, so is my teacher, which again is concerning. Any suggestions?
Thanks in advance for any replies.