Automated Record Navigation Button Needed
I have searched the forums in case this issue was already posted and have not found it, so any help would be greatly appreciate.
I am creating a database so that the user creating the records creates a specific ID for each record and that is recorded in the ID field. Each record has three choices to move to another record. What I want to do is create a button for each of the three choices where it takes the user to that specific record.
This means that as the user moves through the database the three choices change depending on which reocrd they are on.
I've tried using the navigation script for go to record using a calculation, but can't get the calulations to work correctly.
Record 1 ID:1.1 has the following fields
- Choice 1 ID: 2.1 -> clicking this button takes the user to record ID 2.1 where there are three more choices
- Choice 2 ID: 3.1 -> goes to record 3.1
- Choice 3 ID: 4.1 -> goes to record 4.1
I want the button to pull the record ID (2.1/3.1/4.1) from the field and when clicked taked the user to that record. Any way to do this?