You don't have to link them. They are the same record.
If your list view and form view are based on the same table (occurrence) you can just switch layouts and you'll already be on the same record, within the same found set.
I have over 1000 records in the set.
What I neglected to say is that the list view is in a separate window. (both visible form and list view on screen)
I should have said that when I find the record in the list view I would like to click on the record and have it find the record in form view.
The reason for this is if there isn't a record I will need to add it and my thinking is that the list view window for search is easiest option. (mouse only)
Table view is not an option.
Something is missing here.
If the record exists in the list view, it exists.
The form view is just another view of the same record.
Unless it isn't. What is really going on here?
What table is the list view based on; and what table is the form view based on?
OK, so you have two separate windows. Script something like:
Set Variable[ $id ; yourID ]
Select Window[ the main window ]
Enter Find Mode
Set Field[ yourID ; $id ]
Note that you can have a found-set portal in form view.
And various other record selector methods; which do not require you to have two different windows.
What is the user doing at this point?
OK that is great but it is beyond my ken.
How do I make this work what do I link to?
Do i put this in the list view name column?
I am unable to cut and paste your script
I am using 14
Yes, this would be a script attached to a button in your list window. It assumes that you have a unique ID field for each record, e.g. an auto-entered serial number. That is ideal but you could use any field that is theoretically unique for your data set, like a name or email address.
The idea is that you're doing a Find for that ID in the main window, using an ID that you grab from the list window. I think if you start making the script, the options will become fairly obvious. Feel free to ask more questions if you get stuck.
The user is checking to see if there is an existing record.
If there is an existing record the user then goes to the form window and hits find existing record by typing in a record name in the name field.I have set it as auto complete but this is a trap if the user tabs out of the field then the record then becomes the property of the field that is on screen.
Perhaps I should have the search button clear existing fields first before doing the search.
I am trying to lessen the users use of the keyboard. if they can scroll the list view and click on it rather than type in search box.