Using date effective tables in a view
When writing a select statement or using a query you do not have to worry about if the table is a date effective table or not, the frame work handles this for you and will as default return the record that is current. If you are using a view however you need to do a bit more work to get your view to get a single record out.
Firstly you need to locate the date effective table in your view and then move the ValidTo and ValidFrom fields in to the fields list:
With that done. Bring up the properties of the view and at the bottom you will see the following which you need to set to yes:
This will make your view respect the date effective settings on the table.
Please note: you will only see the effects of this within the form, not within table browser.
