Dear experts -
I have an expense table, with 2 fields Vendor_ID and deadline (date).
When saving record, I need to look against a vendor availability table (fields: Vendor_ID, startdate, enddate).
I want to see if this vendor's deadline falls within the start and end date in ANY related record.
1) What type of indexes do I need on the related table?
2) What is the fastest way to check - do i use a dcount function, or is something else faster?