How do you populate an associate table in MS Access 2003?

By DickStretton ·
I have a database linking volunteers to the tasks that they have volunteered for. Volunteer info is stored in one table and details of jobs in a second. I have an association table containing the VolunteerID with the appropriate JobID. I want to create a form which shows all the jobs available with those that a chosen volunteer has signed up for to be indicated e.g. by highlighting or tick box. How do I do this?

Any help would be welcome. N.B my ability with Access is limited!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Hmm there's a few bits to this.

by Tony Hopkinson In reply to How do you populate an as ...

You need to look up how to do a join in Access

This might give you a start

For some reason the article uses the name external join, when the accepted name is outer...

You want Volunteers inner join to Assocations right outer joined to jobs.

The tick box idea could be lot more complex.
For those jobs where the volunteer hasn't volunteered, JobID etc will be null.
You'd have to add a calculated field for that of type boolean with true when JobID is not null.

If you want to use the control to volunteer or unvolunteer for a job.
That's basically inserting or deeleting records from the association table.

Suspect you are going to need VBA to do
that. It will be pretty though and a worthwhile learning exercise.

Collapse -

Populating Association tables

by DickStretton In reply to Hmm there's a few bits to ...

Many thanks for the suggestions. As I can't use VBA I may have bitten off more than I can chew!

Collapse -

Plenty of books and tutorials out there

by Tony Hopkinson In reply to Populating Association ta ...

Personally I'd go for a book on developing applications with Access.

The thing you have to remember about access is if you step outside it's comfort zone, you'll be fighting it, and victory (if any) will cost you.

This one should be doable as far as I understand, though it might get messy.

If you want to learn lots of ins and outs about Access, Susan Harkins who knows it upside down and backwards posts a fair few articles on this site.

Related Discussions

Related Forums