andrewtraub

Fully Normalized Database and Presentation Layer

Discussion created by andrewtraub on Oct 5, 2012
Latest reply on Oct 10, 2012 by coherentkris

I don't understand something in FileMaker.

 

This is what I believe a fully normalized database would look like:

 

Table

Phones

Field

PhoneID (pk)

Phone (text)

PhoneType (number, foreign key, referenced PhoneTypeID in table PhoneType)

 

Table

PhoneType

Fields

PhoneTypeID (pk)

Type (text)

 

That's easy to do in FileMaker, but what I have trouble is displaying the PhoneType::Text instead of the PhoneType::PhoneTypeID after it has been selected.

 

I've created a Value List called "Phone Type" with the first column set to PhoneTypeID and the second column set to Type and checked the "Show values only from the second field." This works well in a drop-down but once the field has been exited, the number is displayed and not the text. What am I missing?

 

Thanks,

 

Andrew

Outcomes