Jump to content

Food Menu System


Themusic
 Share

This topic is 2359 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Sketch-.jpg

Link to comment
Share on other sites

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

  • Like 1
Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2359 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.