Jump to content

Sari

Members
  • Posts

    63
  • Joined

  • Last visited

About Sari

  • Birthday 05/17/1961

Sari's Achievements

Enthusiast

Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. I don't seem to be able to get rid of the black even when I've entered the field. It is only when I come out and click on another area of the screen I can see what I've written. I had no idea how much I correct as I type!!
  2. I have a portal on a tabbed page. The layout background is black, my tab background is grey, the fields + labels are a black font. When I try to add a record to the portal it highlights the row in black so I can't see what I am typing. Now I could just change the type to another colour but I would rather not. Please can anybody help with the minor irritant?!
  3. :thumbup: Many thanks, I'll try that.
  4. I have 3 time fields: Time_Start, Time_Finish and Time_Duration. I want to be able to: 1. Automatically return the difference between Time_Start and Time_Finish into Time_Duration. 2. The sum of Time_Duration. Please, can anybody tell me the best way of doing this? Should Time_Duration be a Calculated Field giving a time result or a Time Field with an auto enter calculation? What is the difference between the 2 ways of doing it? Many thanks in advance.
  5. :help: I have upgraded from FMP 7 to FMP 8 Advanced and can open my files by double clicking on them if I launch FMP 8 Advanced first. However, if I don't launch the program first I get the following message: The operation could not be completed An unexpected error occured (error code - 10660) Has anybody got any ideas please?
  6. Whilst I found this works, I can't help worrying that this solution creates a many to many relationship. Don't I have to worry about that? :qwery:
  7. So many thanks for that. I can see it now .... til the next time!! :blond:
  8. Thanks for looking Kip. What do I have to do with my relationships to make this conditional value work?
  9. Hi, I thought I had this tucked under my belt but seem to be having a problem! I have a layout based on tbl_Quote and when I input a company code I want to be able to choose a Job No which is related to that company. I've attached my relationship diagram and the value list dialogue box. Incidentally, I'm using a trial upgrade to Pro 8 until the CD arrives - just can't wait. Many thanks in advance. Quote_Job_No.pdf Quote_Relationship.pdf
  10. If you need anything else please let me know tbl_Quote_Line_Items.pdf Quote_rel_tab.pdf
  11. I'm attaching some files which might help. Tbl_Estimate.pdf Tbl_Quote.pdf
  12. Got there in the end but thanks for trying to look!
  13. Durr - no wonder I can't manage a script when I can't even remember to attach the doc! Thanks for pointing that out. Quote_View.pdf
  14. I'm trying to compose a script which will perform a find and if records aren't found letting the user input their search criteria again. I've managed to get it to put up the error message if there are no records found but seem to have an eternal loop if there are records found. It seems my Exit Script If step is wrong. Basically I want to exit if records are found but just can't work out the syntax. I've attached the script for those who can help (when you've stopped giggling at the amateur!) : :
  15. I've got 3 tables: tbl_Quote, tbl_Quote_Line_Items and Estimate. Basically the user enters a breakdown of what they think a job will need in the estimate. They don't necessarily use the figures in the estimate for the quote, it is just a rough guide. However, bought in items entered in the estimate table are used. I am trying to do a forecast layout based on table estimate but I need the actual quote total (Summary field) which is in tbl_Quote_Line_Items. I seem to be having difficulty getting it to display. I've tried defining a lookup field in tbl_estimate to get the quote total from tbl_Quote_Line_Items so I can use a summary field to get the information I need but that doesn't work either. Has anybody got any solutions that don't include a gun to the head? Thanks
×
×
  • Create New...

Important Information

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