Recent content by Beemerang

Hi Dave Thanks for taking the time to reply! Yep, you are correct. The ID is the equivalent of a social security number issued by the state. Your approach is exactly the way I decided to go, incidentally. I had hoped that at some point I would be able to change this "proper" ID number to be...

Hi JHB, Thanks for the response! The ID number is user entered (it is similar to a social security number). As individuals attend training, their id numbers will be collected from them and entered into the database. Thanks for the flag idea, that is useful! Beem

Hi All I am under pressure from the client to import data for individuals into the database despite not having their preassigned unique identity number available for every individual. This ID number is the primary key for the table in which individuals' records are stored. Can anyone suggest a...

Thanks for taking the time to reply mate. Beem

Hi All I'm really stuck and I've tried this from more than one angle: (See the attached graphic) I have a list of survey questions that I need to enter collected responses for into a database. These questions all relate to a school. I have a school table and a survey table. Some of the survey...

Out of curiosity, what would the other ways to implement this be? Beem

Thanks a lot for the response, Simon. That makes sense. So I gather that a junction table is the only way to implement this? Beem

Hi All Hypothetical example: I have a long questionnaire (50 questions plus) for which the answers need to be captured into a table. The questionnaire deals with questions about restaurants (for which I already have a table in my database) e.g. meals offered, quality of food etc. The tricky...

I'm posting a pic of the relationships as the database is pretty big, I hope this helps. Thanks mate! Beem PS: I am about to go into a couple of meetings so I will reply to any further messages as soon as I can. B

You pretty much grasped it perfectly despite my poor explanation! The only correction: I have several sets of enrollment datA for the list of schools collected on different dates. So I might have 10 enrollment data records for the same school with each set of data having been collected at a...

Thanks for the quick response! Now for the million dollar question, any suggestion on the best way to go about it? I haven't worked in Access for years so any advice would be welcome. Thanks again, Beem

Hi All I have a table containing schools. I have another table that contains sets of enrollment data which have been collected for these schools. These sets of enrollment may be collected on several different dates, but all the records with the same date, belongs to the same "collection set"...

Thanks mate! Beem

Great idea! Let me do some reading and get back to you if I get stuck? Thanks mate! Beem

Hi Mile-O, Thanks for responding. As always, there is too little time and too much to be done. :-) If there is no other way, I'll probably have to redesign. Beem