database design help needed

[princeofdumph]

i am having problem with designing a database. it is about touring expenses of sales force. i have two tables of fixed allowances. one contains allowances that are specific to given city only; the other contains allowances that depend upon designation of a sales force person. i want to join them with the employees table. but i am confused about the next step after joining these three tables in the relationship window.




i want a report wherein on each separate page, the name and designation of a sales force person is shown alongwith ONLY the fixed allowances for which he is eligible. Since the combination of fixed allowances for each employee is different, i am confused about how to do this? Should i create a crosstab query to achieve this, or by using a code to bind the eligible allowances to a specific employee? if a code is required, then what should it be? help plz

[dblife]

each employee should have their own allowance in the employee table but there should also be a table with destinations and their corresponding allowance.
the amount on the report would be a calculation of the two.

[lugnutmonkey]

Are the employees traveling or are they mostly fixed to a single city(therefore tied to a single city specific allowance)