ContributionsMost RecentMost LikesSolutionsRe: Splitting, totaling, and reporting of loads by ""ShareholderCreated Prototype Screenshot. Neal NealPatil @ gmx.comRe: Has there been a change or an issue with Roles lately?Check roles and permissions in the current system. If it looks fine then create support ticket to resolve the problem. You can create new roles and assign to the users followed by testing but it will involve understanding current permissions, roles etc. - Only advantage in this method is that you do not need to give admin permission to all the users. Regards, Neal NealPatil @ gmx.comRe: Auto populate a field in a join table of a many-to-many relationship?Hi Neil, Regarding the following : "Now if I can get the Replicon table setup where it is auto populated with the Project Information table data, then I will be happy." You can create lookup field on Replicon which gets data from "Project Information" . Relationship of "Project Information" with "Replicon" would allow that. Thanks, NealRe: Auto populate a field in a join table of a many-to-many relationship?Hi Neil, I will try to create prototype screenshots after understanding data and relationships.Visual description might be helpful in resolution. You have many to many relationship between Projects and ProjectsInformation. It means you would have three tables Projects ProjectsInformation Projects-ProjectsInformation which has info from both Projects and ProjectsInformation You also have many to many relationship between Projects and Replicon. So it might have 3 tables Projects Replicon Projects-Replicon which has info from both Projects and Replicon. Questions : (1)What are the tables(with fields) and relationships do you have? (2)Do you have any sample data for the tables? Thanks, Neal NealPatil @ gmx.comRe: Eliminating double schedulingI developed custom app for resource booking in the past. It becomes necessary to compare timing of the proposed booking with the previous booked resources . Link for booking i.e. Book_It will not show up if there is any conflict with previous bookings. Neal NealPatil @ gmx.com Re: Multiple Children with Multiple ParentsI have created screenshot prototype : I have assumed that values of permit-status are shared by different types of permits. NealPatil @ gmx.com Re: Show Properties based on Customer PreferencesMick, I have created prototype screenshots. Following is for Customer Preferences - each record has link to show properties based upon preferences and clicking the link should show properties as per preferences. Following is the list of properties. Following is the list of properties that would be shown to customer1. Following is the list of properties for customer2. Following is the list of properties for customer3. Please send me email to nealpatil @ gmx.com if you are interested then I can build prototype. Thanks, NealRe: How to make a summary report from multiple tables?Hi Ben, Please let me know if the following data represents the data in your question. Projects Table ---------------------- Project1 Project2 Tasks Table Task Project Assembly -------------------------------------- Task1 Project1 Assembly1 Task2 Project1 Assembly2 Assemblies Table -------------------- Assembly1 Assembly2 Items Table Item Assembly ----------------- Item1 Assembly1 Item2 Assembly1 Item3 Assembly2 Item4 Assembly2 Find Items required for Project1 ------------------------------------- Item1 Item2 Item3 Item4 Thanks, Neal NealPatil @ gmx.comRe: calculating dates with date formula.You can create a new date-formula field with following type of date-formula for adding one year to the given date. AdjustYear([dt1], +1) In the above example dt1 is a name of the date field. Replace "dt1" with proper date-field-name to which you are adding one year. Neal NealPatil @ gmx.comRe: Upload data from filled PDF Form into multiple tables of database.Thanks Hilary ! Neal