Recent content by UponFrail

Hey everyone. The situation is i need to produce a report that details, all contracts sold, for each months of 2009. I need to calculate, the total income of the contracts for each month (Which i've done). The total sales, which i can't do. I also need to calculate, the total income for the...

Okay guys, I've got my structure sorted out. The aim is, to be able to add contracts, for both New Customers, and Existing Customers. So the input for this, according to my fellow students and teacher, should be my, CustomerTBL and my ContractTBL. With the ContractTBL being the subform...

Okay my teacher explained the tables to me. CustomerTBL, is 1 ContractTBL is 1 PhoneTBL is 1 Therefore the CustomerContractTBL, is the many, which links the tables. So there is 1 customer, with many contracts, and 1 contract, with many phones. That is the whole purpose of that...

MakeTableQueries, were required to minimize duplication. The imported data was just 2 massive tables. Then i did 4 queries, grouped them. Set PK's, and made relationships. The original files has lots of duplication. We are required to make a valid structure with queries. Then use these new...

Yeah, tables, and queries, i understand well. It's the forms, and taking the data from my MakeTableQueries, and being able to, use forms to add data etc. You said CCID(PK), CCID, has 2 primary keys, customerID, and contractID. So say for example, i open up a form, i import the data from the...

So for each contract, with there is 1 phone. However customer can have many contracts or many phones. I'll try what you said. Thank you. I think i'll have to read up more on my access, because this is still confusing me, even though i'm studying A2 Level IT.

The Database, is obviously about a company which sells mobile phones. Offers 8 Range of phones, and has 12 different type of contract, with existing customer who have many contracts. Then in the PhoneTBL, there is the addition of stock_level and stock_reorderlevel. So, the functions should...

The stock level, is when a new order is made, it subtracts one from the stock level. This must also be functional.

There is no duplication in the PhoneTBL, there is 8 phones to choose from, and 12 contracts, to choose from.

The PhoneTBL includes: Make of Phone, Bluetooth, MP3, Stock Level, Stock Reorder Level, PhoneID ContractTBL: Duration, Type of Contract, Start Date Of Contract, ContractID, etc

Yeah i agree with that. But my teacher said there should be 4 tables including, with the CustomerContractTBL, which now seems like a pointless table.

My teacher drew up the structure and designed. She said something about the table, making it one to many, instead of many to many.

There is 4 tables. Customer TBL, CustomerContractTBL, ContractTBL, and PhoneTBL The relationships are; CustomerID -> CustomerID (CustomerTBL -> CustomerContractTBL) ContractID -> ContractID (CustomerContractTBL -> ContractTBL) PhoneID -> PhoneID...

Basically yes. The concept is that, you lookup existing customers, and view their current contracts. But also be able to add new contracts, as well as adding new customers, and being able to add new contracts for them as well.

DCB, i've got all my files at school. However my friend, has a copy of the database, this is a slightly different database, because the primary key has a different name, and there is one extra field, but he will post it up as soon as possible, again thanks for your help (: