Uncooperative cascading menu

[JDH]

I am attaching a small sample.

 

I am using a table called Contact as my main data entry layout. This table is linked to another table called Professional Data, which stores specific professional information about each contact.

 

To facilitate data entry I placed a portal in the Contact layout populated with fields from the Professional Data table. These fields are set to function as cascading menus.

 

The cascade is triggered by the value placed in the first field (Facility). The problem is that this first field won't enter or show a value until after I have manually entered a value in the second field. Once that is done the rest of the menus work as intended.

 

It will make much more sense to see the example.

 

Thanks,

JDH

[AHunter3]

"Department" needs to show all values, not "related values only". You don't have a related record for the same facility to HAVE any related values from until you create that first portal record!