sojahseh

Hello all, I have a database that I use to run a small manufacturing business. I have a complete history of our production, and I'd like to give access to some of this information to a couple of my largest customers via the web. How can I give them access to only the records that pertain to them? I have set up an account with privileges for one customer, but all the fields say no access, and all the records are available. I'd like to set it up so that when one of them logs in, they can only see records pertaining to them, using the customer ID# I imagine. What am I missing? Thanks, MVC

Brilliant, worked like a charm. Thank you both.

Forgive my naïveté, calculations have not been my thing. Here's what I have in the calculation dialog: "Entry Date: " & Date & "¶" "Customer Name: " & Customer Name "¶" But I get the alert that an operator is expected here: and have the second line highlighted. What am I missing?

Hello all, I have a layout in my database that I am trying to use as an order entry form. When the form is complete, I'd like the database to send out an email with the body of the email being a list of field names and contents of the record displayed as a list. Like this: Entry Date: January 20, 2009 Customer Name: 3M etc. I've been trying this using the FM email feature, but it only lets you include the contents of one field. So I was thinking if there is a calculation that I could use to list the info as formatted above, in one field and then include that in the body of the email, that would solve the problem. Does this sound logical? Is there a better way that people normally use to achieve this? I look forward to hearing from you. MVC

Orlando, Works perfectly! Thanks so much for your help. It always amazes me how much sense these solutions make after the fact. Of course having them spelled out for you doesn't hur either. Thanks again, Matt

Orlando, Got it. Thanks so much. How to display that info has been bugging me for a while now. One other thing though. How would I go about filtering and or sorting the results of the List calculation? Currently the numbers are displayed in ascending order, descending would be better. Also, the Invoicing file is much younger than the Shop Order file, so the early SO#'s are all missing. Thanks in advance, Matt

Orlando, Thanks for the help. As I read it, this set-up will return unused SO#'s and display them in the field in the Invoicing file. Is this correct? I set up the calcs and fields as outlined but got no results. I should clarify that there are no gaps in the Shop Order numbers in the in the Jobs database, only in the Invoicing database. So as it stands, there are Shop Order Numbers that have no invoices. There are also Shop orders that span two or three invoices. I have the invoicing database related to the jobs database. At the creation of a new invoice the file asks for the Shop Order number and looks up the pertinent fields info. Do I have this right, or am I misunderstanding the set-up? Thanks in advance, Matt

I've been using FMPro for a while with no formal training, so I am a bit of a beginner when it comes to a lot of the topics discussed here, so please bear with me. I have two related databases. One is a job database that contains all the processing details of each of the production runs we have. Each record in this database is called a Shop Order, and each has a SO# which is a serialized number auto-entered on creation. The other is an invoicing database that creates invoices for these Shop Orders. Is there a way I can have a field in the invoicing database which will show me which shop order numbers are not in the invoicing database? I look forward to hearing from you all. Matt

I have 4 repeating fields in the database I that I currently use, and I am dying to get rid of them, but I am not sure how, any help does just that. Some background: The database is used at a manufacturing company which produces plastic in roll form. A typical order that we receive would be 10000 lbs of product, that might come on 50 200lb rolls. When an order comes in, I create a record, which contains all the production data, customer info, along with specs. on each of the 50 rolls, i.e. weigh, length and roll number etc., these are the repeating fields. Most orders start with roll# 1001, however some customers require us to use a serialized number for their rolls. What I have right now is 4 repeating fields (50 repetitions each), one for roll #, weight, length, and pallet#. Getting roll numbers to serialize in repeating fields is beyond me, never mind getting them look back at the last number used in a particular sequence. Any suggestions?

Hello all, I have a situation that currently requires me to use about 8 repeating fields each with about 50 repetitions. Each of the repeating fields are arranged vertically, and each row then represents 8 different criteria on a specific item. Using this approach definately has its limitations, but I am not sure how to replace them. I am beginning to need to use serialized numbers as identification but the number have to continue through different records. Additionally I need to have 3 or 4 different series of serialized numbers, qhich will always be at different numbers. Can anyone help? Or point me in the right dierction? Thanks in advance, Matt

I must tell you, what I am really grappling with is a framework in which I can accomplish this. I am relatively new to Filemaker but have put together most of the databases that my company uses on a daily basis. My situation is this. Each month we get in thousands of pounds of raw material, but only in a few varieties. Throughout the month deductions are made from these stockpiles and are used different jobs. I am trying to not so much track the inventory amounts (would be nice), but to ease the month end inventory process. Would creating a record for each box of material as it comes in the door, then making deductions within the record be viable? Or would it be better to create an Incoming Materials file, then a Materials Used file and do the appropriate math? Is there anyone who makes a product which could serve as a framework for what I am doing? As it stands right now, I am really short of time. I fear this might take an inordinately long time to create from scratch. Thanks in advance

Hello, I have a dilemma which I hope I can get some feedback on from you all. I run a growing manufacturing business and I am beginning to run into problems with inventory control, more specifically, doing a physical count at the end of each month to post to the books. We are using Macs along with FM Pro 5. What I am trying to accomplish is to develop a system which will help me track raw material inventories. This would both help me manage purchasing, as well as month end inventory. I need to know if a bar code system would be able to track my inventory in real time. Is it possible to enter an item and then a beginning weight, then track deductions from the original weight? I may be in way over my head here, but in theory it doesn

You might try Thermopatch, Inc. they are in Syracuse, NY their number is 315.446.8110. They make thermal adhesive labels for any number of purposes in the textile industry. They are nice people and are very knowledgeable. Hope this helps.