ContributionsMost RecentMost LikesSolutionsRe: Master to Detail Records - Quicker way to do this?Mark Just trying to take you back on this. In my case as soon as a project is 'activated' I would like the master to detail action take place. Could you help with this as suggested? Automatically creating master to detail recordsI have a button that creates a set number of records in the child table. Is there a way to automate this creation of records as soon as the status of the project is changed? Re: Sorting of Records in A Summary ReportThanks. This is all good. appreciate your help. Re: Date variable App WideThanks. This works fine with the example I used. Many thanks for the insight. Re: Sorting of Records in A Summary ReportThanks a lot Mark. The first option could work but the choices are linked to a table (banners) created by you. So I am really left with the good old option of creating a formula field. And the another formula field to remove the numbering. Re: Sorting of Records in A Summary ReportIt is sorting in alpha order at the moment, I would like to have an order predefined which can best achieved by adding a prefix number but I am preferring not to have unsightly numbers in values. Re: Sorting of Records in A Summary ReportNeed some help here. Re: Date variable App WideThanks a lot. Do need any special format to create the value or can I just add a date "30/06/2017" and that will come across as text and then converted to date. Date variable App WideI have some fields which will need to show results based on financial year start and end date. Instead of hard coding, it there a way we could keep these values somewhere which could be used across app and updated as and when required. Sorting of Records in A Summary ReportIs there an alternative way to sort records in a summary report rather than resorting to additional formula field. As an example my depts are currently alpha sorted and I need a certain order.