I am very new to this program, and databases in general.
I am wanting to created a database that will help track and manage data for music festival management.
I currently hold all the information that i use and collect in spreadsheets, and want to migrate it all to a database.
As i hope it will cut down the amount for information to be entered and better streamline the process.
I have read though the missing manual for Filemaker 10 and have grasped some basics, and i am using filemaker 10 on OSX.
I have created the following tables
This table will hold all the information for the event, Event Name, Location, Times, Contact Names of Key Management Positions, etc
This is the main working table that will pull all the information from all the other tables to make the event.
This will collect; Item, Qty, Location, Dept, Comment, Del, Col.
This is a list of items that can be used on the event site, such as Toilets, Site Sheds, Fence, Barriers, ect. There can be multiple of each, such as Toilets as these can be broken down in to different types, Portaloo, Male Block, Female block, Combo Block, 16 Pan, etc.
Also in this table it will reference the supplier that can supply the product and the cost associated .
This is just a list of departments that each item can be charged back to.
At the end of each event we need to be able to produce a report of the charge backs for accounting purposes.
And need to be able to easily modify the list as it can change for event to event.
All the details of the supplies that we are dealing with, and the preferred contact.
All the details of the workers on site.
What I can not get my head around currently is layouts. I know what I want it to do but not how to go about it.
I want one layout based on orders that you can enter data based on location and would like to add multiple item per location such as.
Item QTY DEL COL DEPT
Site Shed 1 Thurs Mon Site
Toilet 2 Fri Mon Site
Table 3 Sat Sat Site
Chair 6 Sat Sat Site
Flags 10 Sat Sat Decor
Water 20 Sat - Bar
Power 1 Thurs Mon Site
I don't know where to start.
Could someone point me in to the right direction? maybe a great web site or book that woul help me along my way.