Meetings (Database Structure Question)

[123]

Hey,

I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not.

I already have the following tables:
Restaurants, Employees and Meetings

So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent?

Thanks in advance,

Mike

Edited July 26, 2017 by 123

[Steve Martino]

I would think the MeetingAttendees join table on the right path with the field for present/absent.  Actually I don't think you need that field because if an employee is listed as an attendee, then they are present.  If not listed absent.

The FM training series (I know 12 had it) has a section specifically about this.   How to select attendees, and how the relationships are set up.

[123]

Thanks for the reply,

there is a starter solution called "Meetings", however it doesn't solve my problem. There aren't any attendees involved, it's only about meetings and topics.

[Steve Martino]

I was referring to the FileMaker Pro 12 Training Series.  

I tried searching for it for about 20 minutes and couldn't find a link.  Must be dancing right in front of me.

[Lee Smith]

Hi Steve,

Is this what you are looking for?  community.filemaker

Here is the actual link. http://info2.filemaker.com/FTS-Downloads.html

Edited July 26, 2017 by Lee Smith
add the link

[Lee Smith]

Hi Mike,

Did you read my Private Message?

The file you want is in the FTS Advance 15, Core Files, FTS_Meetings

[Steve Martino]

Hey Lee, that's it.  I don't know why I couldn't find it.  I was in the first link and thought I clicked on everything.

[Lee Smith]

Hi Steve

Yep, they have managed to hide it pretty well.

Lee

[123]

Thanks for the help, I figured it out.

Best regards,

Mike

[Rafael Santana]

I'd create a text field in the Meetings table with a list of IDs (separated by returns) of the Resturant's employees present.

You should display the list of employees as buttons at one side, then clicking a name can trigger the addition of an ID to the list.

[comment]

On 7/11/2019 at 3:23 PM, Rafael Santana said:

a text field in the Meetings table with a list of IDs

That's a possibility - although it limits your reporting options.

Anyway, if you want to go that way, a simple checkbox would do. No need for " list of employees as buttons at one side".

 

Edited July 13, 2019 by comment