Hi all,
I am a bit stumped on this but I think I need to implement a junction table.. which I have never done before.
Basically someone reports an event in to my main table, it is assigned an ID number etc.
I then have another table which contains a list of possible investigation types. This is set out with a primary key autonumber and then the list of various unique investigation types.
I want to create a form where the user is able to select multiple investigation types (using checkboxes or a list box) and this will be linked to my main table.
So for event ID number 200 I would be able to have assigned 3 or the 15 event types.
How do I go about structuring this with my relationships? and possibly a junction table?
Regards,
Chris
I am a bit stumped on this but I think I need to implement a junction table.. which I have never done before.
Basically someone reports an event in to my main table, it is assigned an ID number etc.
I then have another table which contains a list of possible investigation types. This is set out with a primary key autonumber and then the list of various unique investigation types.
I want to create a form where the user is able to select multiple investigation types (using checkboxes or a list box) and this will be linked to my main table.
So for event ID number 200 I would be able to have assigned 3 or the 15 event types.
How do I go about structuring this with my relationships? and possibly a junction table?
Regards,
Chris