ryan93

Create a field called Record Number. Create a script: Loop Set Field["Record Number","Status(Current Record Number") Go to Record/Request[Exit after last,Next] End Loop Now put this field (Record Number) on your layout and do a find for <=12 this will show the first 12 records. Ryan ryan_nasco@hotmail.com

This is very simple. Set-up a new relationship to the same file. Application on the left side to application on the right side. Define a new value list, use values from field, select only related values, and choose that relationship you just created. Use the value of the version number. Then set your version field to a pop-up list with this new value list you just defined. Now it will only list those versions based on whatever application you choose. HTH Ryan ryan_nasco@hotmail.com [This message has been edited by ryan93 (edited August 07, 2000).]

How do you get the price from the original file to the file with name, address, etc? Is it a lookup? Calculation? If calculation do you have the result set to number? If it's text it won't work. Is your price field set up as a number field and not a text field? There are many things to consider with this problem. Yes we'll need more info. But first remember this, anytime you do calculations you need a field that is set as a number. Check the fields associated with this calculation and make sure they are number fields or pre-existing calculations. Ryan ryan_nasco@hotmail.com

Your message is quite confusing to me. I'm not quite sure what you've done so far. So I'll just kind of explain how to set-up a relationship. You can have a one to many, one to one, and many to many relationship. The best type to get to is a one to many. This means for every one record there are many related to it. For instance you have an employee with an employee ID and that employee has three telephone numbers. This is a one to many, one employee ID to many (3) phone numbers. What you need is a match field, and that field has to be in both files. If you have an employee ID of 123 then in the other file you would have many records with employee ID of 123. So in the main file create a field and then create that same field in the relating file. Setup the relationship linking those two fields then make sure to select the "allow creation of related records". Also when putting fields in the portals, make sure you have the field set through the relationship you've established. HTH Ryan ryan_nasco@hotmail.com

You can set different CM, Inches, and Pixels. I like to arrange all my sizes in the pixels mode. Everything changes to the number you specify. Click view ->Object Size. On the little window that appears click on the Inches, CM, or Pixels on the right and it will change.

Off hand what I can think of is that you set-up a field that's a check box. When the salesperson enters the information that the estimator needs, have them check the check box. Or do this with a script step, create new record and set a field. Then make a layout that's like a report and lists all the records that have a checkmark. Then the estimator will know all the records that need his attention. When the estimator is done with the record have him uncheck the check box. Or have two values "Open" and "Closed". Check "Open" for open estimate and "Closed" for a closed or finished estimate. HTH Ryan ryan_nasco@hotmail.com

Hi all, I have recently set-up a layout where I have a portal that filters out only portal rows that have a purchase order number or a purchase order number recieved value. This causes me to have a relationship to filter out this data. This is fine and it works great. Now I would like to fix those portals. I have successfully done that as well. But by doing that you need another relationship. My question is can you set-up a portal to have 2 relationships? I would like to have fixed and filtered portals. If anybody has any ideas please help! I'm open to changing my design as well. Thank you to everyone. ------------------ Ryan ryan_nasco@hotmail.com

Hi all, I have recently set-up a layout where I have a portal that filters out only portal rows that have a purchase order number or a purchase order number recieved value. This causes me to have a relationship to filter out this data. This is fine and it works great. Now I would like to fix those portals. I have successfully done that as well. But by doing that you need another relationship. My question is can you set-up a portal to have 2 relationships? I would like to have fixed and filtered portals. If anybody has any ideas please help! I'm open to changing my design as well. Thank you to everyone. ------------------ Ryan ryan_nasco@hotmail.com

quote: Originally posted by Louisa: Hi, I'm creating databases using FMP 5 on an iMac using OS9. Every so often the files are copied to my obsses computer an Apply Laptop which is also running FMP 5 and OS9. What I noticed this morning when I looked at his files is that the font used in the headers of the layouts is different from the one I defined it to be. I set the Header font to be Calisto MT and the body to be Arial in my files. In his, however, both the header and body use Arial (the header looks like Arial, not sure cause I couldn't look, but it wasn't Calisto.) It doesn't look bad, but the other way it just looks nicer! I'm just wondering if this is a result of the copying or what or a difference in machine set-up. Thanks. Hi Louisa, I'm just taking a stab in the dark here but it sounds like the machine that isn't using the Calisto font might not have that font installed on the computer. Therefore, it's using the next closest font available. Check to see if the Calisto font you want to use is available on the laptop. hth ------------------ Ryan ryan_nasco@hotmail.com

Does anybody know how to fix portals? I need to have a scroll bar cuz there are multiple records, but I don't want it to go back to the first portal row after I click outside the portal. If I'm looking at the 50th portal row then I want it to stay there. Any ideas??? Thanks in advance. ------------------ Ryan ryan_nasco@hotmail.com

Just off the top of my head it should be possible. Make a script that opens the files you need open. When it gets to steps where you have to enter passwords use the "insert text" script command under the "Fields" category. Then just type in what the password is under "specify." Hope this works. P.S. I'm an intern as well. I'm interning for accounting and developing an inventory database that tracks purchases and material requisitions. I know Access but they want it on FMP 5. So I know what you're going through. Good luck! ------------------ Ryan ryan_nasco@hotmail.com

I have watched some videos and training CD's from MacAcademy. Here is their url http://www.macacademy.com/index2.html It will cost you a little money but they do a good job. They start from basic all the way to experienced users. Let me know how it works out for you. ------------------ Ryan ryan_nasco@hotmail.com

Here's a thought. This will work if each individual customer has a price increased by the same percent for each product. Give each customer a field called Percent Markup. Make it a lookup field in your line items. Then your cost would have the formula: Cost = Unit Price x (1+Percent Markup Field) Just don't show the Percent Markup Field on your invoice...the customer might get suspicious. That's the thought I had for now. Good Luck! ------------------ Ryan ryan_nasco@hotmail.com

Here's yet another solution. You need three fields Today's Date Birth Date Age Use the formula Age=(Today's Date-Birth Date)/365 This calculation gives you the number of days between today's date and the birth date. So when you divide it by 365 you get the number of years. There is a drawback to this calculation as well. It does not take into account for leap years. ------------------ Ryan ryan_nasco@hotmail.com

I'm not quite sure if I totally understand what you want, but I will try. My guess would be that you have a database of land developments and a field w/in the database would be sold or a for sale field. So that when you sell a land development you mark it as sold. My guess would be to make your map on a layout. Then in each land development put it's related record's field for sold or for sale. Then when you mark it as being sold it should show up in your map. I hope I understood you correctly and I hope you can make sense of this. ------------------ Ryan ryan_nasco@hotmail.com