AnsweredAssumed Answered

either a drop down that is filtered or ability to checkboxes that inputs the information into a join...

Question asked by sweetcuda on Aug 18, 2011
Latest reply on Aug 18, 2011 by philmodjunk

Title

either a drop down that is filtered or ability to checkboxes that inputs the information into a join table

Post

Let me start out by saying UGggg!! I have been working on this beast for some time now and everytime I think I have it designed correctly I get told by someone that I do not and I cannot seem to figure out how to get the database to do what I want. I am by no means a programmer so I need babysteps to help me through any scripting etc. Here is my issue. I have two different databases but the issue I have is basically the same for both. I need an easy input interface for selecting items that relate to another table. I will start with my first DB since it seems the simplest. I have a DB that has to track tasks completed for a training event and what team completed it. I have four tables:

Team Table

TeamID:TeamID->TrainingEvent:TeamID

TrainingEvent table

TrainingEvent:TeamID<-Team:TeamID

TrainingEvent:TrainingEventID->TrainingEvent_Task:TrainingEventID

Training Event_task Table

TrainingEvent_task:TrainingEventID<-TrainingEvent:TrainingEventID

TrainingEvent_task:TaskID<Task:TaskID

Task Table

Task:TaskID->TrainingEvent:TaskID

TaskGroup Table

TaskGroup:TaskGroupID->Task:TaskGroupID

 

I am trying to do a layout where I Can have the individual who is documenting the tasks completed for the training event can pick the group or limit the list of tasks to each task group and then pick from that list the tasks that go into the join table (TrainingEvent_task Table). I cannot seem to figure it out. I have tried making a second task table and make a field for TaskGroupCalc, and do a cal for each task ID but I am not hving luck. Does anyone have any suggestions on how to make this simple.

I tried to use a checkbox field but it enters multiple ID's in one field and I know that is not correct.

 

Thanks,
Lesley

Outcomes