Best way to Link Tables

[LinnyLou]

Hi, I'm the artistic director for a performing arts group. I'm currently
casting our show. I've built a database that will automatically create a
casting sheet (form) for every member with all the numbers in the show
they've been cast in. I'm really having a hard time though figuring out how
to get their actual schedule into an easy to read format for the cast. Right
now I have a separate excel spreadsheet that I'm actually manually
highlighting the times they need to be at rehearsal, then saving that ss for
each individual. I figure there has to be a better way right. I haven't
used access on a daily basis for a few years and I'm not thinking through the
whole db thing as clearly. Any suggestions? Should I load the rehearsal
schedule into a table and then link based on the song name? Except songs may
have mutiple rehearsal schedules, (ie, dancers, singers, actors) and they
don't all have to be at all of those rehearsals. Thanks so much for any ideas
you have!

 

[Jeff Boyce]

It all starts with the data, and I'm not at all clear what your data
structure looks like.

Once that's clearer, can you create a query that pulls the pieces together
you want to see in your report? There's seldom a need to create a new
table, especially if only for a report. Instead, use a query to return the
data, then feed that into the report.

Good luck

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.