Title
Linking Record to a Specific Layout Question
Post
Is there anyway to link a record so that it only displays in a certain layout?
I have three different types of products that require slightly different specifications however they are related enough that one database makes sense. I have a specific layout for each product so inputing the data in the right layout isn't a problem.
The issue is I'd like it so that a requester can see all their product requests but in the appropriate layout however I'm not sure how that would be done. Any ideas?
If you hide the side bar so that you can control navigating through the records, this is possible. If you have a field for Type with your three values, and each record is labeled as one of the three types, then let users flip through records using buttons you create that run scripts (instead of just a "go to next record" command).
The script would be a simple:
GoToRecord/Request (Next)
If (Type = A)
GoToLayout (DataEntryA)
ElseIf (Type = B)
GoToLayout (DataEntryB)
Else
GoToLayout (DataEntryC)
EndIf
You can use equivalent scripts for going to previous record, first record, last record, etc.
Just be careful to include that "if" statement in any script that brings someone to the data entry screen.
Hope that helps.