I am trying to make an invoice on my file maker program.

I have a parts Table and and Invoice table

when i am using my invoice maker i have drop down menus that pull part names from the parts table, but i have a feild right next to it for the part price. How do i get it to automaticly put the price in? The data is stored in the Parts table along with the part name and ect.

Even if you dont want to explain this to me if you know the name of the process i need to use to do this i can look it up myself. I just dont know where to start.

Thanks in advance

Matty

I am going to assume that you are pulling the part names to your invoice table using the unique ID. There should be a relationship set up between the tables using this ID, and if there's not, then you probably have some work to do between your tables.

However, if you DO have such a relationship set up, then...

Double click the price field while in layout mode in your invoice table. From the window that opens, click the dropdown-list on the right side, labeled "Display data from:". Choose your parts table, and select the price field. This should pull the price down as soon as you choose the associated part, given that it's that part name field that's defining the relationship between the tables.

Thanks for the help, thats what ive been looking for. I will fiddle around with it for a bit and see what i can make it do.