Hopefully "multiple records on each tab" means that you either have portals on each tab or you really have a multiple layouts that simulate a tab control but the tabs are really buttons that change layouts. If you have multiple fields in the same record to record multiple contacts, for example, you have significant problem with the design of your database.
What you are describing is a many to many relationship. A given contact can sign up for many workshops and yet each workshop will be linked to many different contacts. This is called a many to many relationship. Before seeing if this can be done with your current layout, we need to start with a simpler approach in order to describe the relationships that need to be set up.
Start with these relationships:
contacts::__pkcontactID = contact_workshop::_fkcontactID
workshops::__pkworkshopID = contact_workshop::_fkworkshopID
You can place a portal to contact_workshop on the contacts layout to list and select workshops records for each given contacts record. Fields from workshops can be included in the Portal to show additional info about each selected workshops record and the _fkworkshopID field can be set up with a value list for selecting workshops records by their ID field.
I have uploaded an image of the 2 tabs for you to look at to see if the layout is correct. I will try the relationships and let you know
I don't see any portals. I suspect that your "tabs" are really buttons to different layouts. If it really is a tab control, then your database design has a significant problem.
What would I need to do to change the layout to make this work?
To repeat from my first post,
Before seeing if this can be done with your current layout, we need to start with a simpler approach in order to describe the relationships that need to be set up.
I can't tell the underlying design of your database from a screen shot of your layout. When you open Manage | Database | Tables, you should find different tables defined for show, workshops, venues and contacts. If you find only one table, then you are using the same record to record data on 1 show, 1 workshop, 1 venue and 1 contact which is a recipe for series problems when working with your database. So you need to take a look at what you have first.
Assuming that you have the needed tables, I suggest to create a new layout for contacts and a new layout for workshops to use as a "test bed" for setting up your needed relationships and getting them to work without the added complications of your current design. Please note that my suggested solution includes adding a new table to serve as the "join table" between contacts and workshops.
And I forget a link in my first comment: For an explanation of the notation that I am using to describe the tables and relationships, see the first post of: Common Forum Relationship and Field Notations Explained
Here is what I find when I open Manage | Database | Tables I think it means we have the right set up. Am currently working on the test bed and layout so will probably have lots more questions.
I would need to see the relationships used to link these tables with enough info to know which serve as the basis for your layouts.
Here is the view of the relationships set up already. I am a new user to Filemaker and know the basics but know very little about the "backstage" work that needs to happen to make it work. So any help is greatly appreciated.
..with enough info to know which serve as the basis for your layouts.
You need to enter layout mode and explore your layouts. By selecting different layouts from the layout dropdown or by clicking the pages of your "book" control in the upper left corner (while in layout mode), you should be able to find out if you have a set of similar layouts or just one. By entering layout setup, you can check to see what is specified in the "show records from" dialog. The name selected there will correspond to one of the Tutorial: What are Table Occurrences? "boxes" in your latest screen shot. I need to know which of the above occurrences is the basis for your layout. My guess is that you may have several layouts designed to look like the same layout but each based on a different table occurrence.
The Workshop tab is linked to the Shows table and the Contact tab is linked to the Contacts table.
Which means that they are not tabs but are layouts--just as I have predicted.
Decribe "Events" in your system. It would seem that an "event" is a particular workshop taking place at a specific venue--which implies that it also taking place at a specific data/time.
If i am right, signing up a contact for a workshop would really be signing them up for a particular event, the presentation of a particular workshop at a particular date and time.
That is correct, we run workshops (events) that happen at a certain place at a certain time.