muskee

Hi guys! I would kindly appreciate your help! I need a report for my employees uniforms. I have the employee table where I have these variables: employeCat, shirt size, shirt amount , pants size, pants amount, shoe size, shoe amount (employeCat can be administrative, designer, reception) So, I made 3 summary fields to add up the amounts and thus obtain the totals of each item. Soo, I'm having problems when creating the report, can't get it to work. For example, I need to see the shirt size L and see how much shirts I need for that size and the amount for the category the employee is in. I. E Shirt size L, 11 required for category Administrative Pants size XL, 7 required for category Designer Same for shoes.... And of course eould also need a grand total at the bottom Thanks for your help!

Thanks, solved!

I have 2 databases, each created with filemaker pro 16. They are both mounted on filemaker server 16. So it's database A and database B. In database A I added 3 tables from database B. I made a layout with some portals in database A that show information of database B. Whenever I try to access this layout in database A, I get the login screen asking for my credentials of database B, Is there a way to tell filemaker just to use the admin account and always show the tables from database B with all permissions? (instead of always having to do the login) If I don't put the credentials of an account with permissions to see this data, then the portal will show a message saying " < File missing >"" Would really appreciate your help!

Thank you for everything, that solved the problem!

Hey man, thanks for the tip, but it didn't work, or maybe I did it wrong lol 1) So I created a global field in the Program Field, attached it a value list that brings all of the companies ID 2) Related the global field to an occurrence of ProgramCompany, related global field with CompanyID of the ocurrence 3) Created another field in the program table, made a value list where I got the ProgramID from the table ocurrence and selected include only related values from ProgramCompany Ocurrence

So it's not possible to do the lists even from the companies table?

The value lists are important because I have more than 150 programs, so I need to find the programs related to a certain company. If I select the company and then could only see the related programs to that company, the list would reduce itself to about 10. I just need to get the related programs and obtain the ID, with the id search for the record in the programs table.

No, the purpose of this is to 1) select the company 2) select the program related to the company selected 3)when you select the program, I do a find in the program table and show the information of that found program. But if necessary I guess I could have the drop down lists in another table and make a script to go to the programs table with the selected programID

The dropdown lists should be in the Program table (because I have set up some important finds in this table that need this option) , I'm not sure what you mean with "How"? This is what I wish for

I tried looking in the forum but couldn't find anything similar. I'm having a hard time with creating a value list from a many to many relationship, this is the diagram. The goal is to have 2 drop down lists, ddl 1) shows all of the companies ddl 2) shows the programs that are related to the company selected I'm not sure how to create the conditional value list, do I have to create a table occurrence? if so, of what table? This is what the ProgramCompany table looks like Thank you guys for your time, you're awesome

Thanks guys, solved my problem!

You mean like this?

I did that but I'm confused. First I get the program ID from a value list in the programs table On which field should the value list be on? I have it like this Enrollments:: dates -->have the value list on this field I currently select the program ID and then select the dates but I don't get the information accordingly

Ok, I did that... Related the IdProgram from enrollement with IdProgram from DatesOcurrence. I created a field called GetDates with the drop down list and it filters correctly to show only the related dates to a program. I pick the corresponding date but I don't get the corresponding information (duration, weeks, etc), do I need to create another field?

Hi guys! I made a database for a university. I have the following relationship Student --< Enrollment >--- Program ---- Dates Student table has the students info. The enrollment table has the program the student has done, what grade he got and the date he did that program. Here is how it looks like: Enrollment table Name StudentID Program ProgramID FinalGrade Dates 1) John Smith 10000 Calculus 1 calc-01 4.8 01/01/2017 - 01/04/2017 2) Bob Doe 10001 Calculus 1 calc-01 4.8 01/05/2017 - 15/05/2017 Program table: Name Id Type Calculus 1 calc-01 Course Dates table: DateId ProgramId Duration weeks dates 100 calc-01 100 hours 4 01/01/2017 - 01/04/2017 101 calc-01 50 hours 2 01/05/2017 - 15/05/2017 As naturally, a Program can be opened during different dates in the year. The problem I get is with the dates. I can't pick a specific date I try to enroll a student to a program. I can't relate it to the proper date, they all get related to the data in the first date, in this case dateID: 100. To get the dates is easy, with a drop down list that shows only related records to Programs. In the enrollment table, if I pick the date with the ID 101, nothing happens, I can't relate the dates table so the student can pick the proper dates the course is in. How can I fix this? Reallyyy appreciate your help!