Hello experts
I've got a difficult question)
I have these tables:
table_Consultants which has a field Cons_id. This table contains all consultants.
table_Dates. This table contains all dates for departmental rotas
table_absentees. This table has a field Date which is related one-to many to table_dates and a filed Cons which is related on-to many to table_Consultants. This table has records of absent consultants on each day. There may be one, many or none consultant absent on each day.
table_MDT_reg. This table contains a field Cons related one-to-many to table_consultants, a field Date related one-to many to table_dates and a field MDT also related to another table with types of MDSs.
What I want to achieve is When I open a drop down box (conbobox) for Consultants (filed Cons in table_MDT_reg), I want to limit Consultants only to those who are not absent on that day, eg available.
Is it possible at all?
Many thanks
this is the source for a combobox items in
I've got a difficult question)
I have these tables:
table_Consultants which has a field Cons_id. This table contains all consultants.
table_Dates. This table contains all dates for departmental rotas
table_absentees. This table has a field Date which is related one-to many to table_dates and a filed Cons which is related on-to many to table_Consultants. This table has records of absent consultants on each day. There may be one, many or none consultant absent on each day.
table_MDT_reg. This table contains a field Cons related one-to-many to table_consultants, a field Date related one-to many to table_dates and a field MDT also related to another table with types of MDSs.
What I want to achieve is When I open a drop down box (conbobox) for Consultants (filed Cons in table_MDT_reg), I want to limit Consultants only to those who are not absent on that day, eg available.
Is it possible at all?
Many thanks
this is the source for a combobox items in