moon0129

very helpful... thank you!

How do show numbers as a dollar amount in a calculation. The calculation contains text and the number so I can't use the Format::Number option. I need: Project 1 - $1,000 I am getting Project 1 - 1000 I know I can get the $ by using "$" & Number, but this doesn't add thousands separators. Any easy solutions?

This is kind of hard to explain, but I will do my best. I am working on a job tracking system. It allows me to track time entries and expense entries. I have a table for Job Information, one for Invoices, one for Time entries, and one fore expense entries. The Time Entries and Expense Entries are related to the Invoices table by the Job# and Inv#. This works very similarly to the Job Time Tracker that comes with FM7 Creative Starter Pack, except I have added expense tracking, thus adding another table. I am having trouble when it comes to generating a printable invoice. Because I have created time entries and expense entries in separate tables, I need two portals to show all the information. This makes a good printable invoice difficult because I am so limited to the number of line items that can be displayed. (i.e. 10 or so for time and 10 or so for expenses no matter what) I have considered creating another table between invoices and time entries/expense entries called "line items", which would combines all off the related entries. To me this seems like more than is necessary because I would end up with multiple entries of data. Is there a way that I can dynamically change the number of rows in a portal? Or what is the best way to do this? Does this even make sense?

Thanks, it worked, and it makes a lot of sense now that I think about it.... I knew it was suppose to be easy.

Although it seems like it should be really easy I cannot figure out how to do this. I am creating a time tracking system and I will like to set each time entry to be related to either a Job or a Task, but never both. On my layout I have two pop-up menus, one with Job#'s and one with Task#'s. I would like to be able to select either or, but it I select both a validation message occurs. I am very new to FMP, so this is probably not that difficult. I have tried several options by validating data through a calcuation, but I think I am just doing it wrong. my job field is: tim.job# and my task field is tim.task# I assume that I need to have a validation calculation set for each field, but what does it need to be? Maybe there is function that I just don't know about. I have been trying with IsValid and IsEmpty.