So I created a database

[MajP]

Makes sense now. But makes even more sense for not needing the MVF

 

[Falcone203]

Makes sense now. But makes even more sense for not needing the MVF

So starting here, I would create a "subreport"?

 

[MajP]

Yes you could have a main report with details for a run and a sub report for the FFs on that run.

 

[mike60smart]

Hi

I apologise for missleading you on this issue but you are correct this Form would now look like the attached for adding Firefighters to a run.

 

[mike60smart]

Hi Alan

I have managed to tidy up your Relationship Diagram with what I can see to be your process.

 

[Falcone203]

Hi Alan

I have managed to tidy up your Relationship Diagram with what I can see to be your process.

I will apply these changes and suggestion to a duplicated do and see how it runs. First I need some down time from my paying job.
Curious, are my newly loaded runs in sheets showing up?

 

[mike60smart]

Hi Alan

I am not understanding what you mean by " Curious, are my newly loaded runs in sheets showing up? "

 

[Falcone203]

Hi Alan

I am not understanding what you mean by " Curious, are my newly loaded runs in sheets showing up? "

Hi Alan

I am not understanding what you mean by " Curious, are my newly loaded runs in sheets showing up? "

If you create the "user folder", the program should still connect to google sheets and load current input of runs. It is still live.

 

[Falcone203]

Hi

I apologise for missleading you on this issue but you are correct this Form would now look like the attached for adding Firefighters to a run.

I incorporated both, multivalue and subtable. when you select "Edit"

and choose a run, you can select or deselect "mutual aid", "apparatus" and "responders". then the related table is also update.

 

[mike60smart]

Hi Alan

Sorry but you have completely lost me with your Runs scenario

 

[Falcone203]

Hi Alan

Sorry but you have completely lost me with your Runs scenario

Hi Alan

Sorry but you have completely lost me with your Runs scenario

Where did I lose you, sorry

 

[Falcone203]

Where did I lose you, sorry

??