Search results

Thank you, i will give it thought tomorrow. Someone said that it is hard for a non-programmer, but i am not doing anything liek Northwind :) I think my DB does not have that much data or functionality, so i should be able to get it done! :)

So we are keeping test_nr and have also a TestID. TestID is a primary key and must be included and the BabyID is what ties the record together.

I did 2 years of computer science, then however i moved on to a different speciality and graduated now. But it is all coming back to me, if you think about it, it makes sense. I will post more when i have done it. Hope you guys don't mind me asking a lot of stuff here! :) Thanks once again!

I will delete the table i have now for testing. I will replace it with. Baby ID test_nr test_date date_test_posted postage_tracking_id date_result_received test_outcome - dropdown of outcomes including - retest required. I decided to eliminate Yes/No on retest required and put it in to test...

Thank you! That makes a lot of sense, i can't beleive i didn't think of it before.... i need to learn to think differently, i will do up a new one tomorrow and post some screenshots. Thank you all for your help. I am actually starting to like ACCESS. Just to be safe, it is ok to use a combo...

So with testing table if i understand correctly, rather than having multiple entries, i should mark the tests as if its first, second third fourth or fifth, with a dropdown menu? As in this test is first. And outcome is all clear and close the case. But for example if this test has outcome...

Thank you! I appreciate this very much. I just hope i am not in over my head and it is not something that can be done by a programmer.

Now, attached two screenshots. Relationships work now i think. I may have not done the testing tables as supposed to, someone suggested using a dropdown menu to add 1test, 2test and etc. But i just made a table with these tests, i know it looks clumsy... but i can't figure out how to have a...

Thank you all for help. I will read, learn and post what i came up with! :)

Thank you. This is not a typical doctors surgery database. It is a bit different. I will try to explain what is happening then i will post another screenshot. When a child is born, sample is taken then sent off to laboratory. Then results are received and it is determined whether another...

So let me see that i get this right. Structure should be as follows: I should have personal details of staff table, then table for details of physicians. But for instance when different activities happen with the patient and physician interact, these activities would be in separate tables. As...

Now ... i created a relationship but seems it is not working... The whole point is, that if i enter the patient details i have one batch of info one day, and then next day the other batch. As in baby_mother_clinical_personal and then clinical_staff. However they relate to same patient. As in ID...

I will try and create a structure tomorrow ... i will inform you of my progress if anyone is interested, i want to learn this skill i can see it can be quite valuable!

So i can include the Patient ID (the autoid) in to all other tables, this is how access will see it? Thanks for your replies, it is just that there are at least 7 actions that happen after the main details are written down. Each action has 4 to 5 fields, i want to have a table for actions...

Now i was told that to build in Access 2010 i must leave my mindset of Excel behind. I tried, now when i have a profile of client (patient) there is information that is available straight away and some that is available later. As per advice i separated it all in to different smaller tables...

So as i said i am looking to make my job a bit easier and no money will be coming in any time soon from the top to do so, so its up to me! :) Here is my situtation. I unedrstand the concept of tables, queries and forms. The task i am trying to accomplish is not really that complicated. But...

Hey, I would like to intruduce myself. My name is Val and i recently got a job with a government and it is to do with medical records. :) In order to make my life easier i decided to create an access database (you have no idea how below developed this place is IT wise :(). While i understand...