spokowirus

Ok I found out that I need 2 dimensional array to build this kind of layout. Also I did some Richard Carlton FileMaker Pro 14 Video Course and correct me if I'm wrong but this kind of 2 dimensional array is something impossible for filemaker. (basic postulates) I didn't found any video or file with such structure what I need. There are some posts about 2 dimensional array but nobody success

Thanks, for reply. I now that this is not a specific problem. I know how to create a normal database like: Costumers, dates, product, amount of ordered product but I don’t have any idea how to show that in editable table like that in attachment. Can you send any tutorial , video, anything that show layout similar in function and look like this what I need Thanks I will look at ERD. I’m just after a FileMaker Pro 13 Essential Training

Hi I’m new in Filemaker, but I see lot of advantages using this solution. I have two similar excel one is work schedule and next one is order schedule. I would like to have them in FM. My problem Is to build database which keep the visual and functionality of excels WORK SCHEDULE: The main part of this excel (SCHEUDLE) is connecting dates, workers and type of work to do. I would like to keep the visual form of this excel but it should work as a database. Work to do is editable list of work type. At the upfront you can see date, week day and time start of each shift, colors are pointing different line production (usually there are 2 shifts day/night and we have to lines block line and trey line also there are something like work on empting trays ) Below the main part is dictionary to translate contraction ( OL/K is operator of blocking line, W/PUSTE is forklift on empty side etc. ) and some extra info about production. I will translate last sheudle and add hole excel here. Also I did some pivot table to calculate how often my worker work on each post. It is on GRAF ORDER SCHEDULE At this excel we have similar situation. (I need to delete sensitive data I only keep date from the last month MAY 2016). On the left side you have clients which are extra sorted by type of product they take (BLOCKS / BULK / TRAY ). At the upfront we have dates months, days, week number, total weekly production by product, total day production by product. Last row (IV) is total season order for each client. The main cell is fill with amount of product to do. I should be something like popup menu with order details ( amount of product, order specification, transport specification I will edit that later on ) Please help me build such SHEDULES, I can’t figure out how to start ? P.S. SORRY FOR MY ENGLISH ORDER SCHEUDLE.xls WORK SCHEUDLE.xlsx