AnsweredAssumed Answered

Complete noob working on a database

Question asked by macfiles on Mar 31, 2017
Latest reply on Apr 3, 2017 by macfiles

Hi Everyone,

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!!!

Outcomes