So I'm setting up a database that will track shows for a theatre and
the volunteers that work each show.

My events table looks something like:

eventsID
eventName
eventDate
....

my volunteer table looks like

volunteerID
volunteerFirstName
volunteerLastName
....

my events_volunteers table looks like:

eventID
volunteerID
position

okay... but now I'm having trouble assigning volunteers to the shows to
created a new events_volunteers entry. I've tried everything that my
filemaker book shows, all throughout this list and even experimented
more, but I can't seem to find an acceptable solution.

I'd like to be able to be looking at an event with a list of volunteers
in hand and just have to search for the volunteer and click an add
button to add them to the list of shows.

anyone have any ideas?

I have created a small file. I don't know if it will answer your problems,
have a look at it and mail me if you need.

http://home.wanadoo.nl/ursus.kirk/theater.fp7


--
Keep well,
Ursus


"spiffy" <spiffyuser (AT) gmail (DOT) com> schreef in bericht
news:1154717776.381563.36370 (AT) m79g2000cwm (DOT) googlegroups.com...

Well, I do have a question for you...

I would like within the layout to be able to search a volunteer's name.
The theatre has over 200 volunteers and remembering IDs and typing
their information each time will be too time consuming for the small
staff...

How would you add the layout so that you can search the available
volunteers and say add them to an event?

Thanks by the way!

Much appreciated,


Ursus wrote:

IN the JOINED table add Drop-downs for the Volunteers and the Events.
You can see the volunteers name or the event name and it will load the
IDs respectively.
TK

spiffy wrote:

spiffy <spiffyuser (AT) gmail (DOT) com> wrote:

Use a field 'link1' in all databases, fill it with '1'. That will allow
you to do popups for selection of volunteers from the events database.

Make a relation eventsID-eventID (likewise, you should call it
volunteersID in your volunteeer table) and an volunteersID-volunteerID
relation. Check the mark indicating you can create related records.

In the events database, make a layout where you have a portal to the
volunteers. In there, on the first line, put a popup of