If you are using an auto-enter calculation, then you can also edit the field directly.
You might also be able to link a work order to all the day records using a relationship with inequality operators instead of =.
WorkORder::StartDate < Schedule::Date AND
WOrkOrder::EndDate > Schedule::Date
is one way that might work.
What do you mean by "If you are using an auto-enter calculation, then you can also edit the field directly"
I created an auto-enter calculation for a LoadInDateTime field in the linking table. The calculation simply reads Invoices::LoadInDateTime.
This way, I don't edit the Invoice directly.
Where do I try this:
"WorkORder::StartDate < Schedule::Date AND
WOrkOrder::EndDate > Schedule::Date" ?
I'm not sure how to do this or where to put it =)
I mean you can place this field on a layout and edit the data in the field to override what the auto-enter calculation entred into this field. A script could be used to modify the contents of the field. If this were a field of type calculation, you wouldn't be able to do that.
What I'm describing in the lower portion of my last post is a way to set up a relationship so that you match to a range of dates, not just one specific date or a list of dates in a text field. This method may or may not be useful to you. Depending on the design of your database system though, it might eliminate the need to edit this field manually.