Food Menu System

[Themusic]

Hi

i'm new to filemaker and programming too. I need to create a layout that allow me to enter daily people's choice between two menus: Menu 1 and Menu 2.

I create a people's table, menu tables and a join table peoples_menu. 

It should be something like this (see attachment)

How can I grab the choice?

How can i create automatically a record every day and check if it already exist?

Thank you in advance.

Themusic

[comment]

4 hours ago, Themusic said:

How can i create automatically a record every day and check if it already exist?

I don't think you should create records in advance, without having real data for them to hold. I would suggest a different approach, where you create/view records for a specific date selected in a global field. See the attached demo. Note that this is a somewhat advanced method; if you're new to Filemaker, it make take a while to sink in.

 

DailySelections.fp7

[Themusic]

Thanks comment. It' an excellent solution. Yes, it's an advanced method for me, but i will try to understand it. 

It's possible with filemaker to make a layout like the previous attachment and if yes, on what table? 

Themusic

[comment]

12 minutes ago, Themusic said:

It's possible with filemaker to make a layout like the previous attachment and if yes, on what table? 

You would have to use a portal to the Peoples table, based on a relationship using the x relational operator.  This could be from any table - perhaps you'd prefer to create a utility table for this.

[Themusic]

Thanks again comment.