ChrisChris
Qrew Assistant Captain
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: If Statment Clarification
Would this be what you mean? if( [Port of Loading]="Vancouver" and [Place of Receipt]="Calgary", [FIELD Z], If( [Port of Loading]="Vancouver" and [Place of Receipt]<>"Calgary", [Voyage Dates - Documentation cut off3], If( [Place of Receipt]="Calgary" and [Port of Loading]<>"Vancouver",[Voyage Dates - Calgary Documentation Cut off] )))0Views0likes0CommentsRe: Drop Down populated, value equals proxy field of related table, but isn't automatically updating
Delete the Airport Name field that stands alone in the Requests table. Use only the Airport Name "Relationship". The proxy field [Airport Name] will serve as your drop down list. In the Requests table, open the Related Airport field properties. Set Airport Name as its proxy. Then you can use Airport Name as the drop down list.0Views0likes0Comments