Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About rdanders

  • Rank
  1. Greetings FM Gurus, As I continue my journey in the deep and abiding mysteries of FileMaker, I find my traditional skills and experience challenged at every step. My question has to do with complex relationships and bringing in information from a "3rd layer" relationship into a form. This example demonstrates how multiple tables can contribute to a central form that is displaying comprehensive information. In other words I need this form to display information from the other tables simply based on related fields. See the DB structures below: There are 3 tables from which I need information in my 4th Table called HuntingSpots. This database is for a space game, so the universe is broken from larger units into smaller units; in this case SYSTEMS have many SECTORS, SECTORS, in turn have many LOCATIONS. LOCATIONS can be a planet, a navigation point, an asteroid, eceteras. Each table is important on its own merits, and now I have a need to create a table that details information at each LOCATIONS. Examine how I have set up these tables and the subsequent related fields. SYSTEMS system_name (text) SECTORS system_id ---related----> system_id LOCATIONS <more fields> sector_id -------------related--> sector_id sector_name (text) location_id <more fields> <more fields> FileMaker has no problem with the 2nd layer relationship, but if you need to extrapolate from a 3rd or even deeper level, how do you do that? For example, consider the the 4th table that pulls information from all 3 tables. Here is it's structure: HUNTINGSPOTS location_id (relational link to LOCATIONS table) Now from the link to LOCATIONS (location_id) I was hoping to pull information from SECTOR via the SECTOR -> LOCATION link, and finally from SYSTEMS, via the SECTOR -> SYSTEM link. I am sure this structure will be familiar, its just getting FileMaker to do what I need that is giving me a bit of a challenge. I hope this is enough to get some suggestions. All respect, Richard
  2. Greetings Exalted FM Gurus, Once again I find myself seeking your esteemed counsel. As it were time is not on my side with my deadline to get a simple database published for a gaming guild for whom I am a member. I have been perusing the help files and this forum, but what I need is a guide to actually get to the point where I can type in my address and see my database in a browser. All me to preempt: First of all I have a cable connection and FM 5.5. I know how to enable Web Companion, but the "how to" of getting to a published database is eluding me. I do have a dynamic DNS setup so the dynamic IP issue is a non-problem. I have downloaded Sambar web server (freeware) in preparation for some advice, I am assuming I do need a web server running right? Hope this is enough information, thanks for taking the time to help a newbie. All respect, Richard D. Anderson II
  3. Greetings FM Gurus...I bow to your magnificence! Well as you can see I am a mere acolyte in the FileMaker universe, I come from an ancient race known as Clipper developers so I know about databases, but the paradigm of using Filemaker is kicking my priestly butt. So here is a question I pose to you. Scenario: 2 tables, a main and a related SYSTEM db --- related to ---> SECTOR db I have successfully created a form with fields from the main db (SYSTEMS) and a portal to a single related table (SECTORS). This form is used to enter data for the Systems db and also the Sector db via the portal, simple enough. As the data grew I decided to create a field on the screen that uses a value list, extrapolated from the System db, that shows the names of each System. I did this using a global variable. What would be great is whenever I select a new value in that pop-up list, I want the record pointer to move to that record. This is where I am hung up, since my paltry skills in FM are sadly limited. Do I do this with a button and script or use a FIND somehow (something I have avoided thus far), or do I pray that FM Gnomes will code it for me whilst I snooze in the night? With your wise guidance I know I can truly become powerful in FM! All respect, Acolyte Richard richard@solve-it.org
  • Create New...

Important Information

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