ContributionsMost RecentMost LikesSolutionsRe: Using a summary report to spot duplicatesIt's working now! Thank you so much! ------------------------------ Anaya Steward ------------------------------ Re: Using a summary report to spot duplicatesFor some reason, when I made the report, it doesn't count any of the duplicates. The summary simply shows the codes and a "1" next to it (I can't show the column with the codes in it since it contains client info). These are some of the settings I used. Have I overlooked something? This is my first time using summary reports. ------------------------------ Anaya Steward ------------------------------ Using a summary report to spot duplicatesHello! Is there any possible way I could use a summary report to spot duplicates of records in the same table? Each record has a formula text field that shows a unique code for each record, however, some of the records have the same unique code. I was wondering if I could use a summary report to find records with the same codes. If not, what should I try? ------------------------------ Anaya Steward ------------------------------Re: Number of records in a report linkHello! Sorry for the late reply. I realize I haven't provided enough information about my intentions. My apologies. There's no relationship connected to the Report Link. The report link matches a Formula - Text field with itself. Any records with the same Formula - Text value within the same table will show up in the Report Link. I'm hoping to check off a checkbox whenever more than 1 record shows up in the Report Link. How could I go about achieving this? Thank you so much! ------------------------------ Anaya Steward ------------------------------ Number of records in a report linkHello! I've created a Report Link in my record and I wanted a way to use the number of records that appear in a Checkbox Formula. For example, I want the checkbox to be checked if the report link has more than 1 record. Is there a way to do this? ------------------------------ Anaya Steward ------------------------------ Populating A Reference Field When Parent Record Is Made After The Child RecordI posted this earlier but I didn't receive any feedback, but we've added a reference field to a child record that has already been submitted and we don't want to have to go back and manually fill in those reference fields for all the other child records that have been submitted. For example, let's say Appointments is the parent table, and Clients is the child. People have already submitted their Clients records, but we've recently added a reference field to the Client table and we want to autopopulate the corresponding Appointment record into that reference field. Is their any method or formula we could use to achieve this? ------------------------------ Anaya Steward ------------------------------Populating A Reference Field When Parent Record Is Made After The Child RecordSo, we've added a reference field to a child record that has already been submitted and we don't want to have to go back and manually fill in those reference fields for all the other child records that have been submitted. For example, let's say Appointments is the parent table, and Clients is the child. People have already submitted their Clients records, but we've recently added a reference field to the Client table and we want to autopopulate the corresponding Appointment record into that reference field. Is their any method or formula we could use to achieve this? ------------------------------ Anaya Steward ------------------------------ Re: Referencing Multiple Records a OnceThank you! ------------------------------ Anaya Steward ------------------------------ Referencing Multiple Records a OnceSo, we have a table full of client information and we want to reference it in another table. However, there are duplicates of certain clients in the first table but some of the info is varied in the duplicates. For example, John Smith has two records in Table 1, both records include his basic info such as DOB, address, etc. However, in Record 1 he has not included a phone number but has included an email. In Record 2, he has included an email but not a phone number. In Table 2, we want a way to get all info related to John Smith without creating multiple reference fields, that way we get both his email and his phone number populated into Table 2's record. Is there any way to achieve this? Sorry if this is confusing, I'll try to clarify if needed. ------------------------------ Anaya Steward ------------------------------