Recent content by pd4life2000

I'll be absolutely honest, im having trouble just adjusting the tables around in the database. I tried to change the name of Client to Infoline and the InfolineAccounts table to Client. The whole thing went a little wrong, even when I changed the fields around, such as putting the client ID in...

Ok I understand what you mean by the client and Infoline Account tables, that makes sense. Shouldn't I then need to change these tables around to reflect the real world? Client should contain details of a client within a company who deals with our company and include their contsct information...

Apologies for the contact issue. Contact was actually a table to detail contact details for the client. If we needed to speak to a particular client in some way shape or form then we would have used those contact details. Our sales people do not actually speak to the clients once the product...

Wow and theres me thinking that I haden't explained it correctly again. Thats exactly how it is. In the database attached (I have attached it once already but just in case) within the table called 'Client', the Customer No is actually the number Graydon uses for generating the Usage. There is...

Wow and theres me thinking that I haden't explained it correctly again. Thats exactly how it is. In the database attached (I have attached it once already but just in case) within the table called 'Client', the Customer No is actually the number Graydon uses for generating the Usage. There is...

Wow and theres me thinking that I haden't explained it correctly again. Thats exactly how it is. In the database attached (I have attached it once already but just in case) within the table called 'Client', the Customer No is actually the number Graydon uses for generating the Usage. There is...

OK, heres the scenario in full. Our service is called the Infoline product, a credit check reporting facility. Although we sign clients up to the service and ultimately send them their bills, they actually access the service through another company in which we part own called Graydon. E.g...

OK This is as far as I have got with fresh data from the start. I have managed to get all of the links to adhere to referential integrity which is better than before. Just need to work out how to get the usage statement in with or without a relationship.

Many thanks for your help with this. The main problem is obviously my Usage import data. Unfortunately as we operate a service for our customers through another company, they ultimately provide us with the data shown in usage, in that exact format. So without manually labouring through 400+...

Hi All, My name is Paul and I am new to this Forum, so I firstly wanted to say hello to all and glad to be here. I need some assistance with a work related database. I am currently developing it as a project but have run into a wall with the design being my first time. I have to create a...