I would recommend using Filemaker's starter solutions to get you most of the way there. No point doing all the heavy lifting if someone has already done it for you. Got to File>New from starter solutions. Choose the invoices solution.
If you still have issues with it or its not giving you the functionality you need, customizing it will be fairly straight forward.
Thank you for you response.But i like to find out why because i want to learn the ins and outs of Filemaker.
Thats great. You've come to the right place.
If you could post some screenshots of your layout and table structure that would be helpful in troubleshooting.
Also, I would use the starter solution as an example of a sollid table structure.
I think your problem is that the layout 'invoice list' is based on the customer table occurance. You need it to be based on the 'Invoices' table occurance and have the related customer fields on that layout.
1.Go to Manage Layouts
2.Double click the list layout
3. Where it says 'Show records From:' select the 'invoices' table occurance.
Let me know how it goes
So its doing the right thing...
Do you want it to show you a list of invoice items along with the invoice?
You could do that but it's preferable to have a list of invoices (in the way you have them). Make the invoice ID or the whole row into a button that will take the user to the 'invoice detail' layout so they can see whats on that invoice.
Use the Go to related record' script step.
Sorry to keep bugging you about the starter solutions but they are good demonstartions that would be useful to you. Open the invoices one and you will see exactly what I am proposing. A list of invioces that takes you to the invoice detail layout when yoiu click on one.
Ok thanks i try that thanks for you help.
I changed the invoice list layout to the lines table ocurrence an it work.You gave me the right idea.Thanks