Jump to content

jeddell

Members
  • Content Count

    18
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jeddell

  • Rank
    member

Profile Information

  • Title
    Designer
  • Industry
    Engineering
  • Gender
    Male
  • Location
    Australia
  • Interests
    Database Design, 3D Engineering Modelling, Technical Illustration

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. New Question: I have a field in a portal detailing hours (ERT). I have a Summary Fields in the table that totals the ERT. What I would like to do is total only the hours for the tasks that have not yet been competed or have not been moved to the next slipping. I'm guessing this will need to be a Calculated field rather than a summary field, but I don't know enough about the syntax yet. So, 1. How to do the calculation, and 2. Is there somewhere that I can go to understand how the syntax works? Cheers Dean
  2. Awesome! Can crack on now. Will check back when I get stuck again...Thanks heaps
  3. Hey Guys, Here's my Video to you as I stated earlier. Topic is Automatically re sizing Layout windows to fit the Layouts. Hope you get a better understanding. Comments on the video welcomed (https://www.youtube.com/watch?v=F-21AuBGhu0&feature=youtu.be)
  4. OK, Thanks guys Wim, Yes I did use the script method rather than the lookup. From what I hear its meant to be a little more efficient anyway. OK, So I made some progress this weekend, although I think a lot of it was just blind luck. This is related to the selecting and setting of the Craft Registered number AFTER I have selected the Craft Type. I struggled with this for a while and I changed the relationship in the RG and it all worked. Unfortunately, I'm not real sure what I did so differently to make it work. I know what I did physically, but don't really understand why its now working. I
  5. gg, It appears as though I stumbled on the "lookup" method, but didn't get it because I was missing some data in the craft Type records. Look up is the answer for this situation. I can progress this further now. My next challenge is to filter a second drop down list (Craft TBL) based on the selection of the first drop down list (CraftType_TBL). I have seen some tutorials on this, but this was where the RG was starting to give me a headache. I'll give it another go with the A/B RG layout and see if it makes sense. Thanks for the advice OK, So I've managed to get the second popup list to sele
  6. Yes, I do have a layout for craft_TBL and for Craft Type Table as well. Each of the layouts will have there own specific roles to play in this solution. What I am working on is the Technical inspections. I started a layout for this, not much design work yet, I wanted to get functionality working first. the technical inspection will be a new record which as Wim post is a snapshot of the data, at the time of creating the record. Much of t he data that goes into the Technical inspection Layout is held in the Craft Type Table and then the craft TBL table. Mu concept was to set a drop-down on th
  7. Haven't got that far yet.....baby steps. Just try to understand the structure before I start asking dumb questions that I could have answered myself with a little learning. Jonathan, Thanks for the info. I'll look at the training material ite you sent. and yes the ID Keys is always set as the first field in all databases I create in <S Access so I am aware of this requirement. What im trying get my head around at the moment is how filemaker manages these relations. Cheers all
  8. OK, Going through t he Anchor Bouy resource. I structured the RG to what the presentation is saying. Is this the attached image the concept, with the Base table being the table used in my Layout? I ask this as the actual relationships haven't changed. I've added another instance of the Craft Table in the hope of establishing a method of pulling in data relating to the craft type table.
  9. Thanks for the Links, I'll wade through them an see how I go. Cheers
  10. Hi all, I've been getting more an more frustrated with the way Filemaker works. I come from and MS Access background and I'm really struggling with Filemaker. I want to learn this, so please forgive me if I dont just hand over my database for you to look at. I did this and someone dazzled me with there brilliance and I ended up deleting the database because it was just way over my head and I could not replicate anything. I am only very new to this program, but I do understand the basics of relational databases I have a project concept that I;m working on of which I have done many similar pro
  11. Yeah, I arrived at that conclusion myself . Thanks all for your help on this Cheers
  12. Sure, Its an XLS or XLXS file both in the zip file. Nothing special about them. They are formatted though, but this didn't make any difference. They had the headings in the first row, but Filemaker can handle that too. CategoryTBL.zip
  13. Not sure why I would want to declare a variable when all I'm trying to do is go FILE>IMPORT RECORDS>FROM FILE. Is this not what the menu should do? I though Specifying the file happened when you selected the file as part of the menu selection process. Tried this method now that you cleared that up. ended up with the same result. This is really frustrating. I might try and different file type to import. OK, I ran through a number of different file extensions the one that worked most solidly was a *.CSV file *.XLS, XLXS, TXT all did not work, when I saved the spreadsheet as a CSV Fi
  14. OK, Started to drill into this and you lost me when I looked at the calulations. Appreciate the effort in solving the issue, however can you help me understand it? 1. Whats the "zxzx zxzx" in the calculatiopn 2. I'm guessing the & P & (Best way to show the symbol) denotes a new line?? 3. Why the calculations and can you break it down? (Remember week old newbie with File maker) 4. Why use IsEmpty? not understanding that calculation at all. While it looks great, and thank you for that, It doesn't help me understand anything you did.
  15. I apologize. I thought I was clear. I Must be using the wrong terminology. I've attached my database. The layout in question is "marine Equipment List." You'll notice the two fields at the top. I think you may only need one however. I really don't care if we use two. The aim for this layout is more of a search tool where I can click to the relevant record in a separate layout. As a sideline (and I'll be happy to place this in a different forum) I seem to be collecting additional table records. I deleted them once or twice to try and get thing to work, but the program keep adding them as instan
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.