Matching transactions across multiple tables

Hi  everyone,

ive come across an issue in my dataset that i need help solving. i have 4 different tables:

-travel extract

-intermediary file

-traveler ID number

-traveller card expenses file

travel extract is linked to intermediary file through a many-to-many relationship between traveler names

intemediary file is linked to traveler ID  number through a one-to-many relationship between the user IDs

traveller ID number is linked to traveler card expenses file through a one-to-many relationship between employee ID

what i am trying to do is verify whether the transactions that are in the travel card expenses file took place within the authorized travel dates (listed as trip date from and trip date to) in the travel extract file.

I've come up with a formula that verifies whether transactions took place between two dates however i am not sure how to link it to the specific travellers (at the moment it is not).

here is the formula i have:

transaction in status = IF('traveller card expenses file'[Transaction Date] < MAX('travel extract for PBI forum'[Trip Date From]) && 'traveller card expenses file'[Transaction Date < MAX('travel extract for PBI forum'[Trip Date To]),"In travel status", "Not in travel status").

all 4 files are accessible using the following link in addition to a screenshot of the relationships between the tables:

https://drive.google.com/drive/folders/1ar4Xp2dwNy2qrZz1EQl18-qnVgeZp2RB?usp=sharing

Any help greatly appreciated!