Chris Good

I have FM7 advanced and I have it installed on my 2k3 server with IIS. Everything seems to be working except that none of the hosted databases are showing up in IWP despite the fact that I have it enabled. Any ideas on this? How do I tell it which databases I want to be availiable on the web, and which ones I don't.

Typically what happends is there are lets say 6 items on an invoice. And 2 of the items come from one supplier, three from another and 1 from another. So I have three suppliers involved with one invoice to a customer. When I print the invoice off I want to be able to print three PO's, one to each supplier. What I can't figure out is how to grab the couple or line item records that belong to a specific supplier and create a new PO, then do the same for each subsequent set of line items.

So here's the deal. I have an order entry database. The tables I have are line items, invoices, suppliers, customers. The line items table contains the individual line items for the invoices and is related to the invoices table using a field called invoice number. Each line item can potentially come from a different supplier, so in my line items table I have a supplier # field that the person entering the item needs to populate when entering the item. On an invoice layout there is a portal that shows the line item records including the supplier # field. When the invoice is entered and ready to be printed, you only need to print one invoice, ut I need to print a purchase order for each supplier only showing their line items. Any ideas how the hell to do this? I have racked my brain all day and I can't think through it.

I would like to create a report of clients that are 30, 60 and 90 days past due on their payments. I could easily create 3 different reports, but could I combine them? A section for 30 days a section for 60 days, etc. Not quite sure how I would do this. Thanks

Thanks for all of the ideas guys. I decided to use the trailing grand summary idea and it is working really well for me now. The one question I came up with though was is there a way to have a field print at the bottom of the last page? I used the footer, but that prints at the bottom of all of the pages and the trailing grand summary prints directly under the body on the last page. Maybe I am being picky.

Hi Ralph, I think I've got that much of it, but what type of section do I put the line items into? I want the totals to print on the last page of the invoice. I tried putting the line items in the body and that got some of the desired result, but then I am not sure where to put the totals.

I want to create a printable invoice. I think I should probably be using sub-summary parts, but I am having trouble figuring that out. I have an orders table and an invoices table that are related using a unique invoice number. The orders table has the individual line items that go on the invoices and then the invoices table does a lot of the calculations such as totals, tax, etc. I think the layout should be based on the orders table. But what type of section do I put the line item info into, and what section do I put the total calc fields into? Any help would be appreciated. Thanks

I like the second idea. I have been playing with this a little bit but I can't quite figure out what to do. I have a table called orders which is related to an invoices table via an invoice #. Orders contains all of the information on each line item. If I setup a new layout for the copy of the invoice where do I put the line item data. It would seem that that should go in the body. What goes in the sub summary leading and trailing section or do I use a trailing grand summary? I also want to have a customer notes field print at the end of an invoice and I want to print a number of fields at the end such as subtotal, downpayment, discount, remainder due. The last few fields I mentioned are part of the invoices table. Thanks for the good ideas.

I have a database that prints out a two page invoice. There is a portal on the layout that spans two pages because the orders have so many items. It works fine for the most part, but if you change the printer then the printable range changes and I have to go in an modiy the layout. Is there a way to link to portals? Can I put on on the first page and then have he second one pick up with the remaining records? Or can you think of another way to get a portal to span two pages?

I am wondering if anyone knows how to mask the data being entered into a field? I have a script that looks to a field for a "password" before running the script. I would like the data that is enetered to not be seen. I know I can change the text color to white and then it's not visible, but you can still see what is being typed as you type it. I would like to to show up as *'s or something is possible. Any ideas?

That works. I was missing the Set Error Capture part. Do you know if I need to trn that off again in the same script?

I have a problem with a script that I wrote. One of the steps is a print step. The problem is that when it stops to ask how many pages to print etc, if they click cancel it asks them if they want to continue with the script. The problem is that lots of people click cancel and then they get stuck in find mode or somewhere that they don't know how to get out of. Is there a way I can use an If statement to just go back to a layout if they hit cancel in the print window? I was thinking Get (LastError) but I'm not sure about that. Thanks

Sorry to have doubted your suggestion. It worked perfectly.

But that would only allow me to specify one variable. have two fields. Actual shipping and Remainder due. I want it to look at actual shipping and it the value is greater than 0 and if the value of remainder due is 0 then "Completed"

I have a partial answer to my question. I changed the field to a calculation that is always validated. The formula is If ( Remainder Due ; 0 ; "Completed" ) but the problem is I want it to also check a field called actual shipping to make sure it is greater than 0 and if both are true then it should mark the order completed. I know this can be done I'm just not sure how.

I have written a script that looks at two fields and if they aren't empty then it it runs a set field step to check a check box. I would like this to run automatically. Perhaps when someone type something into a field, then it runs this script. Is that possible. Can I do that as part off a calculation?

I have an invoicing database at a showroom that employees enter orders into. There is a customer and invoices and orders tables. I want to take a copy of the database with me on my laptop but I want to modify the records on the laptop. The copy on the laptop would then become the master copy of the database, but I want to be able to import new customer records and new invoice records into the copy of the database on my laptop. The problem is I also want to import changes to records onto my laptop, but I don't necessarily want to overwrite all of my changes. Can anyone think of a way to accomplish this?

I'm almost embarassed to reply to this. I had the field set to Text and not date. Thanks

I have a problem where when I search using a date I get a "no records match this set of find requests" error. I am searching an invoice date field that is populated on creation and is indexed. In browse mode the date looks like 1/13/2005 and if I search in that exact same format it works fine. But if I type in 01/15/2005 it doesn't find the record. What is weird is I have another database that this works fine in. What am I missing? Thanks, Chris

I have about 100 db's and just upgraded to FM server 7 and pro 7. I want all of the users to only have data entry access, and they can all use the same password. But I also use the username in filemaker to determine who entered test in some fields so the usernames need to be unique. Is there any way I can set up an account that will accept any username as long as the password entered it correct? The prolem is I have some turnover in staff and if I have to modify the security settings on each file every time I have a new person start it's going to take me forever. I also have Server 7 running on a windows Domain. Can I use that to simplify the security? Thanks for the help.

Stanley you are a god. Thanks for helping us newbies out.

I see. I was able to get it to dsiplay properly when I just put the field in there. but how do I add text. I tried quotes around just the text or around the whole thing and none of that worked.

Can I make a custom dialogue message display a value from a field? For example can I put <<Products::Product Name>> in the message? I tried it and it dodn't work so I assume the answer is no, unless I did it wrong. Thanks guys.

Thanks for this idea. Ugo's is way over my head at this point. I'm still prety new to all of this. When you speciffied gDescription_temp, and the other gFields. Do I need to create new fields for these, or should I make the current field I have global fields. I think I get what the script is doing, just not what specifically the fields you specified are. For example, what is gPortalrow. Thanks for your help on this. Chris

Can you give me an idea of a script I could use to copy two fields in a portal row to a new record in my products table? I have tried a few things and I can get the first field in the portal row to copy but not the second one.