Mariano

I have a value list that references a field that displays all the floors in a building.... Most of the floor fields are numeric, but there are values in there that are actually text, (for example - roof,Basement, Bulkhead) If i make the floor field a text field then the floors arent listed in numerical order (for example - floors 11,12,13,etc come before floor 2), but if i put it as a number field then roof, basement, bulkhead, show up as "?". Is there anyway to do a custom sort order, or any way around this??? I would hate for my value list to not be in order.

never mind....got it!

I read a lot of posts about this, but I still really am not sure how to tackle this. I am hoping someone can provide an explanation using my scenario, I am struggling with getting a grasp on this. I have a start date of a project, and the expected amount of days it will take to complete. I need to calculate the end date of the project,excluding weekends. I read examples with scripts that made some sense, but i need to make this a calculation. I saw a lot that would tell me how many weekdays are in between two dates, but nothing real clear for situations where you did not have an end date. thanks!

Here is how my report is set up: Job# Job Name Material F1111 TEST JOB ENTRANCE DOORS The same job # has multiple lines on the report, each with different material. Is there a way to add a line or some type of visual break in between different job's? So in between job F1111 and F1112 a line break will appear on the report. Thanks!

yea, i checked those too.. They are exactly the same. I have a (hopefully temporary) fix, I just use a solid text baseline on the layout that doesnt print the line in between repeating fields. It looks the same except for the last row of my data. There are borders being display, but only on the exterior of the whole group of repeating fields,so the baseline appears a little bit above the bottom border its very strange, i have tried everything, short of deleting the layout and trying again.

i have 2 layouts that are basically identically set up, however some of the fields are changed in the second one. the format stays the same, but some fields are specified differently. Layout one: i have an area where i enter transmittal data for architectual drawings, the data is on 10 repeating fields in each column. With or without data, if i print i see the lines in between the repeating fields and all of their borders. Layout two: same set up, same area, however the repeating fields arent the same exact fields. The formatting is identical. However, the lines in between repeating fields only print when there is data in each field. when i goto preview i see the lines and borders, but they just dont print in the second layout. The formats are identical!!! Completely confused...anybody have any suggestions?

ah nevermind, i put the button on the actualy field and its working now!

im not sure i am following exactly what you are saying... I tried simply just using specify button on the portal, using goto related record. But that only makes the portal area in between the fields an active button, and those spaces are very small, and it also only works for the first row in the portal. what did i do wrong?

I have seen this done in the Business Tracker database, but I can't seem to figure out how it works. I have a table with a portal displaying all open material orders for a construction job. I want to make each row in the portal a button that will take me to that particular related record. It doesnt seem like this should be hard, but I cant figure out what to do! any suggestions? Thanks

The date will never be before 1/1/1900, I just put that there to eliminate the records that have no date in that field. The Record is found, after the script is ran when I go into submittal data, that record is actually the one being displayed. I can scroll thru the records and find all of the correct related records that are indeed modified, but that one is not. Very strange

I have a table Submittal Reportings, using portals I am pulling all the material needed for a construction job with their corresponding required delivery dates. What I need to do is be able to move all the dates (for this particular job) back by a selected number of weeks. I have a script that creates the new date in a field called NewReqDate, and it almost works. The problem I am facing is that it will updated all of the related records except for the last one. So it looks like my exit loop if statement isnt working right, but im not sure why not. Here is the script: Go to related records [show only related records; from table: “Submittal Data”; Using layout: “Submittal Data” (Submittal Data)] Loop IF [submittal Data::Req_date<1/1/1900] Omit Record Else Set field [submittal data::NewReqDate; Submittal Data::Req_date+((Submittal Reportings::DelayInWeeks*7)] Go to Record/Request/Page [Next] Exit Loop If [submittal Data::NewReqDate>Submittal Data::Req_Date] End If End Loop Goto Layout [“Submittal Reportings” (Submittal Reportings)] Clear [select; Submittal Reportings::DelayInWeeks] any ideas?

Right, but the material may not have been ordered yet. I have the date the material is needed at the site, and the time it takes the vendor to get us the material after the product is ordered. I need to find the items that were not ordered and that will not make it to the site on the required date if ordered today. So if today is 3 weeks away from the date we "require" it at the site and the vendors lead time is 6 weeks, and we dont have it on order, the material needs to be flagged. Often orders arent placed in time due to the approval process of drawings, and the dates we originally set for them to be required at the site need to be pushed back.

i have read a few different posts about using dates, but I haven't had much success understanding or implementing the best way to do this... I have a database with different construction jobs, each job has a list of all material needed for the site with the dates needed, and the vendor it is coming from. I have a seperate table with all the vendor info and their respective lead time in weeks. What I would like to do is flag the items that wont make it in on time based on the current date and the vendors lead time, then incorporate it in a script to email the appropriate project manager.(i pull the email addresses from another table with all of the job contact information). thanks in advance! Mariano

Ok.. your example makes sense to me. And I do understand how that works. But I dont think I explained this as well as I should have. The cars aren't make or models, its actually how the contractor groups them for installation. For Example- Maybe he will choose to install passenger cars 1-6 at one time, 7-10 6 months later, and service cars 6 months after that. I need to designate that grouping. Some jobs maybe do them one at a time. So its always different... I dont know if I could set up a car table because of that. Or am I misunderstanding this?

Thanks for the quick reponses! Perhaps a second table would be the way to go.. but I am not totally convinced. Right now I have each job as its own record. The first layout is Job Description, 2nd layount is Cars, 3rd Layout is Hydraulics, 4th layout is Escalators, 5th is Permits, and the 6th is Layout Drawings. I am still learning FM, I do undertand tables, but I am not sure I get the advantage of doing a different table in this type of layout. Would you mind explaining? I am still trying to figure out the best way to do things in FM. Thanks again!