Search results

i have compared them thoroughly, and i can't see what youve changed..i know you changed something because yours works and mine doesnt, haha hmm...

THANKS!!!!!! Although I'm not sure what you changed. I had the same thing written in control source? (didn't i?) can you tell me where i was going wrong?

i have posted above?

i didnt compact it, but its not huge... Sorry, i knew it was the paperclip, i just couldnt find it... I am having a very slow brain day...

i got it... the form is 'service calls' and im trying to populate 'customer name' after filling in 'customer address' customer address currently autopopulates the customer ID field which is the FK from the customer details table...

I would upload, but i can't work out how... (sorry)

I have a form in which there is a combo box which inserts customer addresses. So if i type in '8' it will list all client street addresses starting with eight and i can click the right one. I have another field which i would like to autofill with the corresponding customer name but I just cant...

please bear with me, there's a chance this question is fairly dumb but: I have put the customer address in there because when employees enter service call information they wont know the customer ID, they will know the street address e.g '10 high street'. Thats why im trying to use that to...

I have a relationship between the customerID in the customers table and customerID in the servicecalls table. Is it worth/does it make a difference, if i make a second relationship between the customer address in both these tables as well?

Ah wow, thanks for such a concise answer!!! We work in street addresses because we are a double glazing company... a 'job' will be a household.. also, we get A LOT of names repeated... Im still getting to grips with Access, so what youve said above will take me a while to get my head round, but...

I have a database with a table of customer details and then a table of service calls to those customers. Following advice from these forums I used an 'autonumber ID' for the customer table as the PK In the service calls table there is an 'autonumber servicecall ID' field as the PK, and has...

I tried to thank you all for your help, but it won't let me for some reason...

:) I think you seriously over estimate my access capabilities.... *goes to find to find out how to 'refer back to the correct autonumber'

I understand the logic of that, However, i don't understand if a fellow employee would need to know the customers autonumber to attatch information to that customer. Basically, if an employee is on the phone to an irate customer and is trying to log a call, could they use the street address...

should i maintain my two tables? and would my link between the tables still be the street address?

Thanks for your input. please bear in mind Im still trying to work access out before tutting at my silly question but: If I have an autonumber as the PI in the customers table, would someone inputting servicecall details need to know the customers autoID in order to link the call to a...

Hi, thanks for your reply. Maybe I am misunderstanding the use of RI.. I am very much a novice at this game.. Basically I have a customers/service calls database.. It has a table with customer details a table with service calls The primary key in the customers details is the street address '10...

When enforcing referential integrity, does access get angry about capital letters? Or just in general, if an address gets put in with a capital letter in one instance and then without in another does it make a difference? thanks for your time

Hi. I'm no expert on access, but i'm giving it a go. Just wondered if someone would check over my plan to spot any holes in it before i start trying to put it together. I have attatched a plan below. I am creating a system whereby our company can monitor aftersales service calls. Our company...

this appears to be the dilema i'm facing, both programmes are capable, but one is hard to start with and easier later, and ones easier to start with then harder later... im gunna give it a go with this database and see where i end up, because there might be other people who will need to input...