creating this data base i found just few problems.
1. How to make a portal in the week report were automatically show all the objects so i can field up the data of how many tickets sold each object.
2. how to make a portal in the objects where will show automatically all the weeks report.
3. Where to store the data of the tickets sold. Should be in a new field or new table ?
I Was looking for video tutorials in internet but I couldn't find. Maybe somebody can help at least with that.
Thank you guys
Try Lynda.com. Excellent FMP tutorials.
Try FileMaker itself -- it has excellent training videos. Check out the training materials.
Try YouTube....Search for "Youtube FileMaker 14"
Unfortunately, AFIK, there's only one current FileMaker 14 book on the market, other than FileMaker's itself, but it's a good one to get started with.
I would be very concerned about a beginner building a full fledged point of sale system that a business will rely on.
IMHO this is not an entry level project because you need to have a level of mastery of FM built in functionality that is way beyond beginner.
You should have advanced knowledge of scripts, custom functions, custom menus, security, layout building, and relationship graph management techniques as well as the ability to learn the benefits and pitfalls of transaction handling in FM.
If you don't also have a solid foundation in basic relational data concepts and how to apply them to tables and TO's you will gradually spend and increasing amount of time refactoring to correct things you have done that dont/cant work instead of building new features.
Your customers will not tolerate "oops" events and will not accept "hey im just learning" as excuse.
They will simply bail.
I agree with Daniel and coherentkris, this can be a large project and you may need assistance. morkus also points to good sources and these can help if you have worked with other database modeling and are simply new to FileMaker.
I also suggest looking at a starter solution that may get you a lot of the way there.
or purchase one with most of what you want:
(and more, search for 'filemaker point of sale')
or look at the MySQL/PHP web solutions out there and use as a basis:
1. to use as-is and connect with FM
2. or to study for what all goes into POS