Re: "When I click on Browse ... the text field disappears."
One possible reason for this behaviour is that the relationship is not set to allow creation of records. When this option is selected a portal will include a blank row. If it is not selected and there are no related records the portal will be empty.
The problem is, is that I have created records for the fields I'm trying to create. So, in my Filemaker, I have already created records for individual musicians located within the proper Fields.
As for "creating new records" ... I'm not looking to create NEW records. I'm looking to be able to ADD musicians already in my system to the Event I'm creating.
I hope this makes sense.
Your basic relationships with event set up as a typical join table between client and band tech.
What's not clear is what you mean when you say you "borrowed " a text field.
The typical way to set this up is to enable "creation" for event in the client to event relationship and set up Band ID Match Field with a value list for selecting a band tech.
Note that with this design, you will have multiple records for the same event if you need more than one tech for an event.
Duplicating entries in my Band/Tech rosters is what I was trying to avoid.
All of this is a bit overwhelming.
What I'm attempting to do is...
Create Events with all relevant detail for each event (gig)...including gig address, date, time, load in, etc etc, Musicians Booked, Tech booked.
I have imported all my Tech/Musicians names and contact info into my Filemaker and was hoping to be able to just add them from a dropdown list or quickly type them into the Event.
I was hoping to pull their names from my already entered data and place them into the EVENT DETAILS.
I have opened up a Starter Solution and am trying to just modify that to work for my needs. But since I'm 48hrs into FileMaker ... I'm still light years behind on how this program works.
Dallas, perhaps the attached demo file will help you get your head around the issues. Note the following:
1. The file contains your three main tables: Clients, Events, Techs, together with a join table (see below)
2. If there is only ever one Client for an Event, this is a one-to-many situation, so you can directly link those two tables, as shown
3. If there may be more than one Tech associated with an Event, and your Techs may be engaged for more than one Event, this is a many-to-many situation, so you need an intermediate Join table to connect Techs to Events. (The join table breaks the many-to-many relationship down into two one-to-manys.)
4. The relationships to the Join table enable creation of the Join record, so that you can create the related Join record simply by entering data in the portal, as shown.
JoinTableDEMO.fmp12.zip 73.6 K
Thanks so much.
My brain is fried and i'm burnt for the day. I'm gonna take a better look at your setup tomorrow.
From what you're telling me in your text, I believe i understand it. I got a semi-good grasp of the One-To-Many relationships when i took the Lynda.com course.
My issue is that I"m having a hard time understanding is when Table A is connected to Table B. Table B is connected to Table C. Is Table A connect to Table C VIA Table B?
I feel as though my Relationships are setup correctly bc I used a Starter Solution template but I just can't get some fields to format correctly.
At any rate, thank you all so much for the help.
If anyone is looking for some tutoring work via Skype, i'd be happy to purchase some tutoring time from an expert to help me understand this.
I'll be back on tomorrow.
Thank you again!
1 of 1 people found this helpful
In agreement with keywords, I think your table setup is incomplete.
Attached is a slight mod to the graph in his example file; plus a modified version of his file.
I suspect you will want to specify the particular tasks or skills the performer/tech will be using in THIS event; as well as perhaps listing their default skills.
You guys are all so great at this and VERY helpful.
I know its a bummer telling someone who has NO clue what they're doing that they have no idea what they're doing.
I'm not a TOTAL idiot so I'm gonna try and take these examples and figure this out
As i stated previously, i grabbed a starter solution and am trying to modify it.
For whatever reason, when i switch to BROWSE mode, in neither my dropdown list nor the entry field am I able to see my BandTech names.
I have triple checked to be sure my settings were the same as the demo's you two posted.
here's some screenshots if they're of any help.
I'm also looking online for some Skype tutorials/lessons/help.
Here is a mod to your copy.
Still mucho unfinished stuff, but with a reorganized graph and some added features that may give you some ideas.
DnD - MODBFR.fmp12.zip 402.2 K
thank you so much!
I'll download now and open her up!
In order to keep myself from posting SO much stuff on this forum ... if anyone is interested in helping me out either via Skype or screeenshare ... I'll gladly pay for your time.
Feel free to leave an email or I guess message me here?