Allocate fee in same period

[Msoh]

I have two tables like this

Table A

Enno      Period              Fee

1          Jan 2023             100

2          Jan 2023              400

1           Jan 2023             200

3           Mar 2023            400

1           Mar 2023            100

3           Mar 2023             200

Table B

AlocateNo  Alocateto     Aloperiod   AMOUNT

1                 2                   Jan 2023           100

1                  3                   Jan 2023          100

Table A - contained Engagement, period and Fee

Table B - contained allocated engagementNo, EngagementNo (that want to alocate to desired engagement ), Alocation period and amounts 

For example, If I want to alocate fee from engagementNo 1 to engagementNo 2and 3,which same period as conditions in table B. How can I alocate correctly. I try many way but my data still duplicate in table A.

[Greg_Deckler · Accepted solution]

@Msoh So in the example you have presented, what do you want your output to be? I'm not clear on that.

[Msoh]

Thank you for your reply. This is the result I want