Hi,
I have encountered a problem in my development. I have a standalone dates table which contains the filed of current fiscal period which I want to 'copy and paste' into another table. The current fiscal period field has one value and is dynamic so you can't hardcode it and it is not the calendar current period. When adding it to the table, all rows in that table will have the value from the current fiscal year. Is anyone aware how it can be done? Many thanks.
Sean