I tried to look up what I need to do, but I'm unable to figure this out.
Firstly, I'd like to point out that I know absolutely nothing about filemaker but I've been tasked with creating a functional database for our department. (BTW I'm a purchasing agent.. not IT)
What I'm trying to do:
I need help figuring out what can link
Products > Workorders > Customers
So that the Products are searchable in the Workorders and those products also show up in (possibly a portal?) the Customer's information. I want this section to show information from the work order in relation to the customer. It needs to have the product sold.
I haven't adjusted this screen yet, because I don't know where to begin. I can't make a portal here unless the workorder screen showing the products somehow can link the products without a portal. I thought about using a drop down list, but there are too many products for that.
Plus, each one needs to have a cost.
Please! Any suggestions!
Also, please dumb it down a bit for me. I've been watching all the videos and took the "training course" that didn't teach me anything at all.
I basically don't know anything about this program but am doing my best!
Thank you all!!!