Automation

[Don]

Hello,
i am trying to create a work allocation procedure in my db. i have created
all tables, customer, order. employee, employee expertise and employee
availablity. the order table has a one to many relationship with the customer
table and the employee table has one to many relationships with the expertise
and availablity tables. so there are to sets of information which have no
relationships

i need another table which completes the relationship but i need this table
to fill itself. i need the database to look at the requirements of the order
in the order table and allocate work to employees which have the expertise
for the requirements and are available to that order. there is also a
deadline for each order, which is set in the order table.

i was thinking to put a allocation table, which would connect the the sets
of data but this needs to be populated by me but i want the db to do this, i
also thought of creating a query but this will not be possible if there is a
gap in the relationships. i am really stuck, will access be able to do this.

Please can somebody help me ?, thank you