Ban me i ask to many questions!

[ColinEssex]

Hay and Lyns

I'm off home soon, thanks for an entertaining afternoon. I thought the changing mobile number and not telling Hay was brill

I look forward to tomorrows postings by Lyns

Col

 

[Hayley Baxter]

Oh thanks Col I had to get rid of my last phone as I was getting funny phone calls It was really quite scary I'm careful about who I give my number to now but I trust you've given you're old phone to someone nice Lyns!!

See you later Col have a nice evening!!
Bye bye

 

[lynsey2]

nope gave it to a serial killer too!

night col!

 

[Hayley Baxter]

oh bugger that's me had it then no more posts or help for you!!

 

[lynsey2]

only kidin!
its in the bin! well it was a contract and its now canceled and dead! so someone might get the number again but i dunno! so your safe! im off home now been at wk since 8ish or there abouts! still fluey so im going to get pissed 2night.. ill catch you 2mo, more than likely ill be freeking out but we will see! my boss wants to use it 2mo so you can imagine what ill be doing...maybe getting pissed will make me solve the problem!?? ill try it n let you know!
see ya!

 

[Hayley Baxter]

See you later Lyns I'll have a look at your db tomorrow I did look at it quickly but I'm a bit behind now as you can imagine so I'm going to stay on for a bit.

 

[Hayley Baxter]

Morning Lyns

Hope you're not feeling too rough this morning after last night!

Just had a look at your db, personally I wouldn't set it up all in the one table.

1 patient can be prescribed many drugs
1 drug can have 1 or many forms ie tablets capsules and the same for strengths. I would make create another table for drugs and join them to the patient table..but hey this is me and you should never listen to what I think as it's always wrong!!

I'll send you a copy back of how I would do it with your combos working as well. When do you need this for? I'm really behind now after yesterday so I've got to crack on this morning.

Hope you're ok
Hay

 

[lynsey2]

i need it for today! im totaly freeking out

OH BY THE WAY getting pissed doesnt help you see an access database any clearer.

 

[Hayley Baxter]

Ok I'm going to get into bother for being behind soon but I'm doing them a favour by coming in tomorrow..can't leave a friend in need.

Be in touch shortly
Hay

 

[lynsey2]

oh no babe i didnt mean that god your works more important! im just avoiding my boss at the mo and hopefuly ill give it to him at the end of the day so i have all day to work on it!
your sooo sweet!

 

[Hayley Baxter]

That's no probs Lyns I really would have done it for you but I'm afraid I've got some urgent stuff on today.

I'll speak with you later got to go into a meeting now
take care
Hay

 

[Hayley Baxter]

How did it go Lyns all sorted??

 

[Hayley Baxter]

HI Lyns

I couldn't find the many to many example which Pat posted but I hope my explanation was ok for you to follow if not here's a post from Pat explaining how this is done. Look up access help and it will show you how to join them if not I'll do it for you this afternoon.

In the meantime have a read through this

http://www.access-programmers.co.uk...did=9393&highlight=many+to+many+relationships

Hay

 

[lynsey2]

your explanation was great im giving that a bash just now hopefuly i will get it! thanks babe your a star!

 

[lynsey2]

oh Hay did you mean that in my other tbls i dont have to put the drug name in?
e.g My Drug frequencey and Drug Strength tbls have 2 fields (drug and frequencey or strength that the drug comes in) do i only need one field with a list of frequencey or strength?

 

[lynsey2]

//QUOTE//
problems using linked combos
Hi All

I am trying to use 3 combos which are all linked to each other but having some problems. The first combo list all the suppliers, it is a two column combo, supp ID (BOUND COLUMN) Supp Name (COLUMN COUNT). The second combo lists a list of contract types ie software, hardware etc so when a supplier is chosen in cbo1 I want all contract types related to this supplier to appear in cbo2 and the 3rd combo lists all the contracts related to supp in cbo1, contract type in cbo2 and on selection of the 3rd it should display all the details in my tab control at the bottom of my form.

I have a sample of 4 combos being linked in this way I have studied it carefully and even tried to copy the expressions and code behind it changing it to match my field names but no matter how hard I try I cannot seem to grasp this.
//UN-QUOTE//

HAY!

this is what i want to do!!!! can you send me a copy of the sample one that Kev sent u!please

 

[Hayley Baxter]

Sure no problem Lyns I see you're stealing my phrase from one of my old posts.

I'll send it in a second

Hay

 

[lynsey2]

thanx babe

 

[Hayley Baxter]

Lyns / Tay

This example which Dawn has posted in this thread is the same example I learned from along with the first one I posted. Now as you can see from my quote above I did struggle with this for a bit. The best advice I can give you both is go into the properties of the 2nd combo and look at the where part this tells you what table etc the combo is getting it's data from and on which field it is looking at in order to synchronise. You will crack it eventually.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33448

Good luck to you both
Hay

 

[lynsey2]

what the ur a star one or just your whole message? lets do the ur a gem one instead!