Need help creating a script to go to a certain record #.

[Nestor]

I have two tables. Each table has its own layout.

My first layout is Home (1 table), and my second Layout is Handbook(2nd table). I'm tring to build a script so i can click on a box in layout 1 to be able to go to a certain record number in Layout 2. How can i do this.

In my layout 2 i have 35 records ,and i have several butons in layout 1 that will need to go to different records in layout 2. Hope this makes sense.

Thanks

[mr_vodka]

can you please explain further why you are trying to do this? Are the records related to each other? Something doesnt sound right.

[Nestor]

The records are not related.

I have an list

Policy 1

Policy 2

etc...

and in my other layout(2nd table)

i have the text to policy 1 (1 record)

Policy 2 (second record) and son on.

so my script right now is go to Layout, but from that point i don't know how to just see the record that i want to see.

[mr_vodka]

Why bother putting it into two tables then? A one to one relationship is good to have in some cases, but in your case it doesnt seems to really fit. You could still have a different layout with the description field from the same table.

[Nestor]

so i can go to a certain record number, but how can i disable all other records. I want to be able to go to a record and only see that record, and then click continue to go back to my original layout.

[Nestor]

Nevermind i figured it out.

Thanks for your input.. I don't know what i was thinking.. Im so ready for the weekend