Do you want to achieve this manually or through a script? There are a number of possibilities depending on the structure of your database and what you want to do.
If you have a self join relationship linking ID to ID. You can script this in two parts:
1) script the necessary steps to "find louis"
2) Use Go to related record to pull up all records related to the found set by their ID numbers. (use the show only related records, match records in found set options.)
Hi - thanks for your reply -
Hmm - I must have missed something. From Edit>Manage Database>Relationships I established a relationship between the ID field in "MyTable" and itself in a duplicate table "MyTable 2". Then I made a script called "NewScript" with one command in it - Go to Related Record[Show only related records:Match found set; From table: "MyTable"; Using layout: <Current Layout>; New window]
Then I manually found the "Louis" subset. Then I went to Scripts > NewScript. The resulting new window contained the same data, no new records were added. I am very sure there are new records with matching ID's to be added.
What do you get when you use "my table 2" instead of "my table" in your Go to related record step?
Wow! that worked! Thanks very much for your help.