Search results

I finally managed to crack this first stage. Just to say thanks to everyone for their patience, and particular thanks to Pat Hartman for her example. Following it exactly was the secret!

OK Based on Pat Hartman's many-to-many example (my apologies, Pat,I'm not a good pupil!) I have three tables - Communities with CommID, Community; HealthProblems with HealthProbID, HealthProb; and a link table with CommFKID and HealthProbFKID. I have a query, qryCommunitytoHealthProb which...

Thanks, George for your recommendation to look at Pat Harman's excellent example. I had worked through it very carefully before posting this. Her's does not use a combo box unfortunately, nor could I clearly see at the time whether the joins were outer or inner.

Fair point - thanks. .mdb version attached. Look forward to your comments!

Would be grateful for some help with this problem which I can then apply to many similar cases. There are two main tables, tblCommunities and tbl HealthProblems, with a join-table, tblCommunityHealthProblems. Attached is a zip file which shows the form I have made to try to add multiple...

Could you point me to some good examples? The one that I have seen in the sample databases is clear on basic design but the detail of the transition from query to form is where I am having problems.

It seems unbelievable to me that a key part of relational database design - the many-to-many relationship of two tables through an intermediate junction table seems to become an arcane art for a beginner making a simple form to enter data in either main table! As an example I have Communites...

Re: Multiple Table data entry So far I have managed to enter data into Organizations and People tables with a people subform. However a more complicated group for example is Community to Dowsing linked to Community Visit and Waterpoint and Team. Even making an effective entry form for Team...

Hi FoFa Since you kindly helped me when I was starting my database I would be very grateful if you could throw some light on the aspect of multiple table data entry - which is wher I've got to now! I've psoted a question on it in the Forms forum. Many thanks John

Hi Alisa You kindly helped me back in July with my first attempts at getting a database together for Village Water. Am now fairly advanced in the table design but am having a challenge with the question of data entry into the joined tables. Have posted a question about this inthe Forms forum...

Answering my own question, here is a data-reduced version of the db in .mdb format. Grateful for your comments on solving the data entry problem with muliple linked tables joined with referential integrity.

Thanks, Rabbie - your point is valid. A naive question - Is there a simple way to post a copy of the db without publishing the confidential data included in it?

As a novice access user I am trying to develop a database for waterpoints, communities and associated data. There are a large number of linked tables with referentially integral joins. This situation must be a very common one. What is the best way to enter data into such tables? Attached is a...

Thanks! Just to say thank you publicly to everyone who has sent me private messages. You have given me a lot to be working on! What a useful and helpful forum. I'm sure I'll be sharing some of my trials and tribulations as I go along.

We are a small charity helping provide rural villagers in Africa with a good water supply and improved hygiene and sanitation. In the last four years we have helped 109 villages in the Western Province of Zambia and this year we will work with another 42. We need to develop a database urgently...