First of all, I want to stress that I have refrained from resorting to forum assistance all weekend whilst I work through online tutorials and videos! After exhausting 2 Lynda.com resources, I am still stuck!
I want to learn FileMaker freelance so that I can create my own personal databases specific to me. One thing I do not want to do is use a starter solution! - nothing wrong with this, just that's not how I learn!
So my issue -
I want to create my own 'Invoices' solution
I do have a few reasons for wanting to create my own - the most important is that I have more bespoke requirements.
As I am still fairly new to database creation with FMP I am going to build a very basic version and expand my knowledge from there. Therefore, I am creating very simply a Customer, Product, Order database.
I have the following tables:
Creating layouts - fine.
Creating a relational layout for an order page - Order ID, Customer Names, etc - fine.
My issue is using the portal tool to create the InvoiceLineItems records!
- I create a portal showing related records from InvoiceLineItems. No sort, no filter and add in the fields very simply Product Name, Cost and RRP. I have then used the All Products table to create a list of product names to select on the portal. When I select a product, it will fill that field with the name but it won't fill the cost and RRP fields with the relevant information?
Can anyone help me solve this issue and actually create a fully functional orders database. What am I doing wrong?
FMP Version: 14 Advanced
Mac OSX: 10.11