AnsweredAssumed Answered

Go to Related Record-Help

Question asked by ChuckCoughlin on Jan 27, 2019
Latest reply on Jan 27, 2019 by comment

I am new to FileMaker and the concept of "Go to Related Record" is very confusing.

 

I have attached a sample FM database-"RelatedSample" to help clarify.

 

Goal: Type a list of part numbers into field LookupList(global) of table Related and have "Go to Related Record" only show those part numbers within the table Part Numbers and layout part numbers.

 

What I have done:

Tables--

Part Numbers & Related

Fields--

Part Numbers Table==>Fields: Part Numbers(Text)

Related Table==>Fields: LookupList(Global)

Relationships--

Part Numbers = LookupList

Scripts--

Lookup: Go to Related Records; From Table: "part Numbers"; Using layout: "Part Numbers" (Part Numbers)]

Buttons to Activate Script--

Layout Related--Lookup Button above List box

 

I have tried to make this example as simple as possible so hopefully, I can understand the concept of how Go to Related Records works.

 

 

Thanks for your advice and help in advance.

Attachments

Outcomes