georgewash

That looks perfect. I'll have a go at it. Thanks!

So, should I import the data into a different table and then display it on my layout via a portal? How do I parse it out? Do I need to manually create the lines in Excel first? BTW, thanks for the help.

What I want is the field to be imported into the following fields in one record: Product Qty Price Total Pick n Click 1 $29.99 $29.99 Extra DVD(s) 2 $10.00 $20.00 The following items in the original .csv file need to be in different fields shown else where in the table layout. Theme: Winter Fun Project Name: You're in Utah Mail Files: 1 I can manually separate and assign these. My difficulty is in getting the Products into a list.

After several hours reading my FMP 8 book and searching these forums, I am still stuck. I'm sure this has been covered and if so, please point me to the thread. I am importing a single line of .csv and want to import it into my FMP database. I know how to import and select the fields to match. What I am having difficulty with is how to handle the field that looks like this: Pick n Click:1:$29.99:$29.99|Pick n Click Extended:1:$25.00:$25.00|Choose Theme:Winter Fun::|Add Extra DVD(s):2:$10.00:$20.00|Project Name:You re in Utah::|Mail Files:1:: I tried to split it into separate columns in Excel by the | and then the :. The problem is that I have multiple products I am trying to include in my Invoice in FMP. If I place the products in a column, I can get the quantity, price, and total to import. What I can't figure out is how to list these in one record. Each line creates a new record. Hopefully this is clear, if not, I can provide a file of how my layout is set up. Thanks!

I imported a bunch of graphics as pictures to use as icons for script triggers. I then changed the location of the graphics to a different folder. Now I have a bunch of boxes saying it can't find the graphic. Is there a way to re-reference the graphics? Thanks

Thanks. Not sure how exactly how to create dummy records from a sales order, but I'll think about it and the other ideas in the link you provided. Sure thought there'd be an easy solution, oh well,

When I generate a sales order, I can print an address label. How do I pick which label on the paper to print to, as opposed to always printing on the upper left corner label? I'm sure it is easy, but I haven't had any luck finding the answer. Thanks.

Have you had a chance to look at this? Are you available for outside projects? You can send me your rates, info etc. Thanks.

I realized I uploaded the wrong file, but I've been having problems editing the post. I think there is an issue with the FMForums server. I'll try to get the right one up tomorrow. Thank you very much. Elements.fp7.zip

Hi Barbara, I hope you find this. I previously applied your sample file to my databases, except I didn't plan on having the 'add' song capability. Now, I realize that I need it. I have tried to use your example but when I hit the 'add' button (a red circle in my case) I get the following error: "This operation not possible because the target is not part of a related table." Looking at your example, your table is not related either and the script works fine. I'm guessing I am missing something simple. If you can take a look at my file I'd really, really appreciate it. Thanks.

That did the trick. Thank you very much.

No, it's the Assignment field that I want to edit. Not a drop down or pop-up, just a empty field to type into. Thanks for your efforts so far.

Tasks layout. Tasks - Create New Assignment from Tasks Thanks.

I decided to add an editable field to a portal that is used to choose 'assignees' from a contact list. This is accomplished through the use of a script. Everything has worked fine so far. My problem is that after I created the Assignment field and added it to the portal it does not allow me to edit the field when the new record is created. I tried a number of ways to get it to be editable, but nothing worked. I am not too knowledgable about scripts, so perhaps it has something to do with how I create the new record. I've attached the file, since trying to describe all of the t.o.s and the relationships will probably only be confusing. I am referring to the Tasks layout. Thanks. Customer_copy.fp7.zip

I knew it was simple. Another example of why modifying someone else's work can end up taking longer than doing it yourself. Thank you very much.

I am talking about the field in Tasks-Form View next to the Project text. It does specify where to display values from - Projects::Name Which field are you refering to?

I've been racking my brains over this one and I am sure I am missing something simple. I have a drop down list that won't display anything but if I type in the ID the correct name shows up. Here are the details: Projects: Project ID Name Tasks: Project ID Task ID Projects Project ID (based on Projects ID) Project ID In Tasks I have a field displaying Projects Project ID::Name, using a drop-down list displaying values from Projects::Name When I click on the field it does not show anything. If I type in the Project ID, the name pops into the field. I've attached the file if anyone wants to take a look. Thanks. BPS_copy.fp7.zip

I took some time to work on other projects and then took another look at this particular issue. After a bit I am able to get pretty close to what I need by concatenating the fields and using the List function. Now I need to figure out how to format the List function if possible. I certainly appreciate all the help. I still have a long way to go, but I'm understanding a bit more all the time.

Boy, I sure stirred up a hornet's nest. I was not referring to his help on this specific topic but on many others to other questions I had. I was simply trying to convey that I did not follow why some of my logic was flawed and that I had gotten to this point by following previous advice from some very talented people. I promise to be more careful with my comments in the future.

Thanks LaRetta, I will look into concatenating and using the list function. It sure will help if I explain WHY I am asking all of these questions! Themes is used to select various elements. It was designed so that the user can only select the records that are appropriate from other table occurrences (Theme FCP and ThemeDJ only allow 'transitions' from FCP and DJ to be selected). It also displays songs with the same type that is chosen by the user. I suppose a list function would be better than a portal (but I don't really know how to use a list function!). So, what I want is to simply DISPLAY & PRINT an individual Theme's elements. That's it. Just a simple list of everything that was chosen or is available for each Theme. Thanks.

Geez. I certainly did not mean to insult anyone. I am very grateful for all of the help I've gotten on these forums. I guess that can be the problem with email and forums - no way to hear a voice or read body language. I am truly sorry that you spent so much time trying to decipher my mess. My process has been to attack each issue as they come up, find out how to make it work and then worry about correcting the naming, getting all the ids correct, and filling in the data. Apparently this is not a very good method as I am finding out. My only reason for stating that what I have so far works is to avoid people from spending a bunch of time going into detail in my file. I thought there might be a big picture point that would help me understand if what I am trying to do is possible and what the approach would be. I thought it might help to look at the file in browse mode to see how it works, not to delve into the relationships. Comment and Barbara (why did I keep thinking Beverly?), sorry to drag you into this. I was only trying to let others know that much of what I did came from your generous help, not to make you look bad. I guess the gist of all this is that trying to get multiple portals to be displayed in a list layout is not straight forward. I'll try to look through other discussions and see if there is another way to achieve what I am after. I have much to learn. I need to get beyond looking at everything as a join table and portal. Again, sorry that I offended some people. I will try to be make sure my comments more accurately reflect my sentiments.

Check out topic #199071 (not sure how to make this a link), to understand what I want to accomplish with the MusicTypes portal. Basically, one picks the music type for the Theme, and MusicTypes simply displays all songs with matching type. I had a hard time following the logic behind how this worked from Beverly's example, but I couldn't get it to work any other way. Thanks.

Thanks for continuing to help with this. I don't see why these portals should be (or could be) combined into one. The data they are using is from different tables. The idea of creating a temp portal to get everything into one portal to be used in the list layout is interesting, but I am not sure how to go about it. Maybe a better explanation of what I have so far will help. If you look at the Themes layout in Browse Mode, you'll see that its purpose is to select various fields that make up each 'theme' (record). Part of the selection process uses 2 portals. Why use portals? Because I don't know of another way to choose more than one item from a given table occurrence. Secondly, these portals are restricted to only show 'transition' records from these table occurrences because those are the only types available to be chosen in Themes. The thing is, Themes works exactly like I want! There have been various comments about the logic being faulty. I grant that I don't understand everything perfectly, but the only way I've gotten it to this point is to follow the advice and examples from people like Comment and Beverly who I trust as being experts. Is my real problem that I am expecting something that is not possible in FM? It just seems as if it should be possible to take all the information in a particular T.O. and get it to display/print in a list, even if there are multiple portals involved. I have cleaned up the Relationship Graph and have reposted the file, if it will help anyone. BTW, I am getting an error every time I try a search so I can't even try to find any help on my own via the forums right now. Thanks again everyone! Elements.fp7.zip

I guess I'm not too clear as to what I'm running up against. My portals work fine. It's when I try to get all of the records from the portal to show up in a list style layout that I can only get one of the records to show up. I'll get my file cleaned up and let you know exactly what I am talking about. Thanks again, I really appreciate it.

Fenton and LaRetta, Thanks for taking the time to look at my file. Yes, I realize it is a total nightmare. It started out as a file someone posted on the forums 3 years ago turning the BPK into a single file. I've since taken bits and pieces from the original BPK, other people's help files, and my own additons. Then I realized I needed to split my original file into 2. As I've gone along I have not cleaned up the messes I've created. Somehow it actually is becoming very functional. For the question I posted, the relationships are simply copied from a file Beverly did to help me extract the correct songs via its types in Themes. Her solution was not exactly what I needed and I haven't taken out the extra bits yet. My problem is I don't understand how to get a layout to display all the records from multiple portals. Fenton, you mentioned multi-line fields in your post. What is that? It's the first time I've heard of it. If there is a simple way to display multiple records instead of a portal that would probably help me quite a bit. I will clean up my file and properly name everything - it needs to be done eventually and now is probably the best time. In the mean time if anyone can point me in the right direction as to how display multiple records (in a generic sense) I would appreciate it. Thanks again.