AnsweredAssumed Answered

Displaying related data?

Question asked by arosales on Nov 1, 2018
Latest reply on Nov 7, 2018 by arosales

I'm new to filemaker and I'm not sure how to setup a field. I used the contacts started app to create a student database. One table for students and another for advising notes. One student can have many advising notes.

 

I added a portal to student detail with date, contact type, and description. My issue is the contact type and description both have shortened abbreviations for reporting. There aren't very many contact types or descriptions.

 

Contact Type

CC - Collateral contact

CP - Case Planning

EM - Email

FF - Face to Face

etc...

 

Description

ED - Education

FE - Finances

HE - Health - Mental Health

HO - Housing

ID - Identity

LS - Life Skills

O - Other

RE - Relationships

 

Is a table for each (contact and descriptions) required to get the following to display? Or is there a lookup and replace I should do.

 

Portal

Jon Snow  10/31/2018  Face to Face  Education

 

Report layout

Jon Snow 10/31/2018 FF  ED

 

 

 

Outcomes