Bioboy

is there a way to print more than one label per record? I would like to be able to print package labels from FMP, but sometimes I need 50 labels per record, other times only 6 or 10. the number always changes so i can't make a layout for each quantity.

Hi, I am using FMP tp detail a number of products that our company sells. I would like to make a custom label for each product. I have designed the label format etc., but I don't know how to say, print 30 labels for one record. All I can get it to do is print one label per record. The number of labels required will vary for every run. Any ideas? Also, do I need a header for this type of layout? If I delete the header part I seem to lose text on the body part. Wierd. Thanks for any help you can offer.

Once again, I am leaning on the forum to help me with a problem. I need to add a new field to my inventory database, that describes a costing category for each record. The categories are Raw1, Raw2, WIP1, WIP2, and FP. The categories are dependant on 3 other fields, Format, Status, and Supplier. For example, if a record denotes a product as being from Supplier "X", and it's Format is "Liquid", and it's Status is "Evaluated" then it is in Raw2. If it's Status was "To Be Evaluated", it would be in Raw2. There are 5 Costing Categories, each with a set of critera based on the three fields above. There is no overlap, meaning that none of the product could exist in two categories. Is this operation best done via a script or the Case function as a calculation? What would these scenarios look like? I am so lost ! Thanks in advance to all who reply, and sorry for the long post.

Argh... I tried that kurt, and while it works, if the Follow Up Required field is set to "No" I get a question mark (for invalid data) in the Follow Up Date Field. I am using this calculation: Follow Up Date = If(Follow Up Required = "Yes", Date Modified + 7,"N/A") I know this is a small issue but now it's driving me batty! F.

Hey Folks, I have a tech support database that contains a Follow Up Date field. A small script searches for any follow-ups that need to be done on that day when a tech opens the database in the morning. The Follow Up Date field is a calc. based on the Date Created field. It looks like: Follow Up Date = If (Follow Up Required = "Yes", Date Created + 7, "N/A") The result is set to "Date" and it works great. But now the techs have asked that I make that field modifyable, so that they can change it if they can't get a hold of the client on that day, or the client says "Call me back next week." or whatever. For the life of me, I can't make this field both Auto-enter, and modifyable. I tried setting the field result to "Text" and then using the same calc, but it does not work. Any suggestions? Frank

liveOak, I can see how this will work, but when I plug it into my script, the script , the Insert Text command pastes the "..." over the whole field, eliminating the StartDate value. I double checked that the "select" option is OFF, but it makes no difference. Is there a cursor command that I need to use to ADD the inserted text into the field after the StartDate value has been set to the field? I then need to add the EndDate field value into the DateCreated field AFTER the range command. I just don't know how to get around this. Thanks for your response LiveOak.

I am trying to write a script that finds a range of records between StartDate and EndDate fields. I have a Date Created field which is what I wound the search to be done on. I tried using this: Enter Find Mode [] Set Field ["Date Created", "StartDate"] Paste Literal ["Date Created","..."] Paste Result ["Date",EndDate"] Perform Find [] Like the June 5 post from ZuperZZ suggested, but I quickly found out that my version of FM does not have the Paste Literal command in Scriptmaker. Am I missing something (i.e. I'm stoopid) or is it really not there.. Or is there another way to achieve this? Thanks to all who reply.

I need help finding a way to track the amount of time a technician spends on each customer issue. the issues are separate record in a FP5 dbase. normally, I would just use start/end time field and calculate the difference, but the techs often revisit a case two or three times. Having the dbase track the time automatically would be a huge asset. I evisioned something like a count-up timer with a "Pause" command that the tech coul hit when he was not working on the file. Any ideas would be great. Thanks in advance to all who respond.

I am writing a new layout inside a technical support database and need to allow technicians to enter the Catalog Number of the product that the client is having trouble with, and have the Name of the product appear in a second field. The Catalog Number and Product Name information is ina separate database. This is easy for one Catalog Number, it's just a simple relationship between Catalog Number and Name. But because one client can require technical support on many products, I chose to use a repeating field for the Catalog Number. I want to be able to enter say 10 Catalog Numbers, then have the related field, Name report the Name of each Catalog number beside the Catalog Number field. How can I do this? Is the answer in the Extend or Aggregate functions?