relatively

Hello all- looking to hire a FileMaker pro. I am building my own database solution and have been stuck with the relationships in my tables for quite some time now. I have gotten close to a working solution but it seems a little messy and is not quite working. What: I am looking to hire someone to work with me remotely (via zoom) to review my database with me and the relationships between my tables and guide me in the right direction or potentially even help me do the work to get the table relationships completed. Must be a good communicator, ready to dive right in, and must have a solid understanding of relational databases and their implementation within FM. Relatively, I do not believe my project is very big or complicated. There are 11 total tables and my issue really only lies between 3 or 4 of them. Please note I am using FileMaker Pro 15. When: Looking for help ASAP, ideally would meet this week. I am in US-Eastern time zone and would have most availability after 6pm Weekdays or this weekend. We can do one long session or multiple shorter sessions based on our schedules and the need of the project. I will pay hourly based on an agreed upon rate. If you believe you can help and are interested to know more about this job, please reach out so that we can discuss further. Please be able to verify your FileMaker proficiency- such as a digital portfolio of your work, having made substantial contributions in post/comment history on fmforums, a FM certification, or something similar. Thank you for your interest!

I really appreciate your time and reply. I'll try to clarify what is being tracked/the relationships: Personnel can have many tardies and personnel can have many inouts. Essentially, these relationships keep track of when a person is late and when a person is in or out of a performance. A Tardiness record has only one performance date and performance time. Same for an inout record- they only have one performance date and time. The idea is that the report shows all the tardiness records and inout records for a matching performance date and time. I was able to set up the inout correctly but not tardiness. Apologies for the screenshot/file discrepancy, that is indeed confusing. What does "TO" mean here? I guess I actually do want to be basing the portal off tardiness_reports, but that portal was giving me totally incorrect related records whereas tardiness was much closer. So I confused myself. The inout portal you're talking about is, in relation to the report table? I thought that every personnel would be related because the personnel::id = inout::actorOut_id. So then shouldn't every person be related to the report record? Wow, this does look like it was my problem. I didn't realize that the fields in tardiness_reports it were coming in from tardiness... thanks a ton for that. With this fix alone I can move forward, however I am interested in understanding all your earlier points because maybe the way I have set these relationships up isn't the best. I'm not sure if that's all unnecessary though, considering I actually did intend to base the original portal in question on tardiness_reports.

Hi there- new member here so I hope I am posting this in the correct place. I've been messing with two of my table relationships for a long time now and I can't seem to figure out if I've correctly related them. Some records are being displayed as desired in a particular portal, but not all records are. The portal does not have any filters on it so I'm expecting to see ALL related records. Here are my table relationships: Looking specifically at reports and tardiness & tardiness_reports tables, I'm wanting to see all of the tardiness records for a particular report date/time in the report layout. Here are my tardiness entries for March 31: There are three records, so I would hope that all three records show up in the portal for the March 31 report. But for some reason, only the first two do: (You can ignore the tardiness_reports portal, tardiness is showing me what I'd expect but not John Robinson). A link to my test file can be found here: https://www.dropbox.com/s/0cy1f9ybd1t3i2l/Test.fmp12?dl=0 If anyone can take a look or offer advice, that would be great. I've tried a number of things.