Inventory solution - user interface problem.
I got Filemaker about six months ago, and I'm loving the power it's giving me to look into my business. I run a night club and I have just developed an inventory/order system that allows my staff to take inventory and enter the ordered amount using Filemaker Go. It works fine but the people who need to use it complain that the interface isn't easy to use.
The previous solution was a basic excel worksheet that sorted ALL the items alphabetically:
|ITEM NAME||AMOUNT IN STOCK||AMOUNT ORDERED|
I developed a solution in Filemaker using three tables:
ORDER -----< LINE ITEMS >------ PRODUCT DETAIL
On the order layout line items appears as a portal. This is where the problem arises.
In the Line Items portal using a drop down value list based on the product details foreign key my crew then needs to choose a product (for instance: coca cola) and then proceed to enter amount in stock and amount ordered.
Because we have about 125 different products it gets cumbersome to enter each product on to the Line Items portal. I would need a solution that lists ALL of my products at one given time so that they would only need to enter the amount on stock and the amount ordered. I'm thinking of something like in table view, since my crew have gotten so used to working in alphabetically ordered excel sheet.
Do I need to abandon working with the Line Items table to avoid using a portal and just use two tables? I'm a bit lost, so all help is welcome.