What's your skill level with regards to FileMaker and relational databases?
Here's a simple invoicing demo that will do what you describe that was created by Comment:
Can you make sense of how it works?
I'm a novice at best.
The link you sent doesn't relate to what I'm talking about. From the link you sent, it seems that the items are already set up and you select from the options given. What I'm talking about is the client setting up the items based on what products they use instead of a set of items for them to choose from. Does that make sense? I get the feeling that FM doesn't have that capability that I would like for it to have.
Take another look at the demo file. If you select Products from the layouts drop down, you'll see a table of 26 products with 26 prices. This table can easily be edited to change prices and add or remove products from the list or to just edit a product's name.
Keep in mind that this is a demo that has been deliberatedly kept very simple so that it's easy to see how things work. Much more elaborate systems based on these basic principles are possible.
My boss routinely changes prices and material names in our FileMaker Pro invoicing system just by pulling up a more elaborate version of this same type of table which lists all the materials we invoice here on a daily basis.
I've pulled it up again and when I go to change a product I get a window that says it's not modifiable.
Database files compressed inside a zip folder are read only. Drag a copy of the file outside the zip folder and try again.
I'm unable to drag and drop it. I get the not allowed sign.
Ok, I got it to work now. I had to pull it from the zip file, move it to my desktop, then open it up. It works now.
Not very pretty :) but I see what you mean. I think it would work but I would definitely prefer a different format for doing it in. Any good tutorials out there on this?
And did I say thank you?
It was designed by Comment to be just a basic framework to which you can add the bells and whistles you need. It's important to understand how it works before you try to build your own solution that uses the same priniciples.
There are several books available on FileMaker as well as some online tutorials you can look into for more basic information on how to use FileMaker and you can also post questions here as needed as well.
For a more elaborate example, FileMaker comes with a starter solution that uses a similar table structure but more sophisticated interface. It's not a good design for managing inventory, but it may give you some ideas on how you can enhance the layouts of an Invoicing system.
I agree completely. I'm on Lynda.com and watching the Filemaker videos to gain basic knowledge of the program. Thanks for your help Phil!