angelestevezcalvo

Create a record based on 2 fields

Discussion created by angelestevezcalvo on Apr 25, 2018
Latest reply on May 2, 2018 by angelestevezcalvo

Hi everyone,

I have just discovered Filemaker and started with an application for a school. I have a problem that may be easy but I can't get through it with my basic knowledge in Filemaker...

 

Table 1: Courses

Table 2: Teachers

Table 3: Lessons (occurrence of table Courses)

 

In the table Courses, there are 4 fields:

     c_ID (primary key)

     c_type

     c_id teacher (foreign key)

     c_price

 

I want to create a new lesson based on a teacher and a type of course, so a new record in table Lessons that makes a relationship with table courses based on 2 fields, c_type and c_id teacher, but I don't know exactly how to do it, any recommendation please ? Should I change my table relationships ?

 

Actually, I use a 4th table (Worked_days) with a portal to table Lessons from where I create the new lessons, could I still do it? From table Work_days create a record in table Lessons based on 2 fields from table Courses?

 

 

Screen Shot 2018-04-26 at 00.25.13.png

9o

Outcomes