Conran

Hi- I have a product image folder that I've created in Photoshop that I'm currently importing into filemaker, my question is when I import it, the photo's are not all displaying in the same size, but it's fine in Photoshop. Ultimately I just want these images to display at 100%, and right now some are 30% and some 120% (or that's how it looks) Is there a global setting or function that will control that?

Hi there- Our customer database is broken down that each product a customer requests is it's own separate record. So each customer has multiple records. For this report, I want to be able to see each customer, what is the potential sum of all their requests, the actual sum of what has been purchased and the difference between the two. I can do that for each customer, and it now looks like this: (list serial number) (list serial number) (list serial number) (customers last name)(potential sum)(actual sum)(difference) However I can only do this for one customer at a time because the summaries will summarize all the records in the find. And I want to get rid of the multiple 'list serial number' and just have a summarized version, so it looks like this: (list serial number)(customers last name)(potential sum)(actual sum)(difference) The next level of my summary problem is that I need to be able to find all open accounts, or all accounts for a particular year. But when I find multiple accounts the summary will summarize the whole group that has been found, and gives me outrageous numbers. What I can't figure out is how to summarize the multiple records for each customer into one and then have each customer have it's own separate sum displayed indivdually. Then be able to list all open accounts together in a extended columnar report. So I want it to look like this: 1(date)(list serial number)(customers last name)(potential sum)(actual sum)(difference) 2(date)(list serial number)(customers last name)(potential sum)(actual sum)(difference) 3(date)(list serial number)(customers last name)(potential sum)(actual sum)(difference) Does that make sense? I would be most grateful for any insite into this problem.

Sorry, I'll clarify. In 'Bridal Couple' each couple gets a couple ID# (we call it a list serial number) The list serial number is automatically assigned to all new records -using automatic data entry serial number. I type in all their information name, date of wedding etc. into the corresponding fields. Then I script over to the 'Bridal List', which is set up like a long columnar list/report. I go to new record, the cursor will jump to the 'list serial number' box first. I type in the number press return and the couple's name, wedding date, list creator's name automatically pops into the related fields using a relationship calculation. The actual list is composed of new records because there is an item number (also an automatic serial number) that needs to be assigned to each item on the list. So a new record is needed an 'item number' is assigned and I type in the sku number press return and the description, price and department number automatically enters using another relationship calculation. (And soon a photo, see my querie about setting up a photo database) I was told that the 'item number' is essential because without a new record serial number, you couldn't have multiple people register for the same thing. Having unique numbers attached to the record with the sku makes the record unique and therefore the computer can sort the information when finding individual lists. I'm not quite clear about the difference between a 'portal' and a 'relationship'. I know that there is a relationship calcuation between 'Bridal List' and 'Bridal Couple'. The information that comes with it though is then copied and not directly referenced each time from the original source. So when the related information is copied into the file, is that a relationship or portal? I think it's relational -right? So once that is done, I can find the list in 'bridal list' by typing in the list serial number. The couple with their whole registry comes up, it's then sorted and printed out. What's being lost is the 'Bridal Couple' record. Is that the parent file or is that just another related file? The relational information (serial number, names, dates, etc.) that's in 'Bridal List' is still there. I can still type in the list serial number and it will still find the couple with their complete registry in 'Bridal List'. But when I look for the couple in 'Bridal Couple', the record is gone. I can 'find all' and see that the list serial number jumps over the missing record (it goes from 413 to 415 -414 is missing), the record has been deleted, but I haven't even left the terminal. So I believe that the 'Bridal Couple' file has become corrupted, because it's only a problem I'm having in that one file and it's so random in the way it deletes information, I can't find any normal pattern in it that would explain some human error. So what I want to know is that if it is indeed corrupted, 1. Can I reinstall filemaker just for Bridal Couple file? 2. Can I save my layouts & records if I do reinstall it? 3. Can I import the needed records/info from 'Bridal List' (because most of the information is copied into the list) back into 'Bridal Couple'? 4. Will importing the records also import the original serial number with it or is the serial number lost. (If it's lost then I have to redo the entire list with a new serial number) Sorry for the long explanation, but maybe that will help clarify things. Thanks.

Hi there- This is a similar question to 'losing data', however, I need it to go to the next level. I know for a fact that it is not because I'm entering information in a 'find' or 'global fields', or because someone is deleting information on me, or even because the file is being closed improperly. Like 'losing data', I have a certain amount of records one minute and then less records the next. My database is broken down into 4 different sections essentially: 1. Bridal Couple, 2. Bridal List, 3. Bridal Purchases, 4. Bridal management (letters etc) Bridal Couple being the parent file and the others being the children. (I'm new to this, but I think that is my understanding of the difference of the parent/child thing) To start a list, I need to create a new record which will give me a unique number that I use to reference the original information in the other files. (Can't get the number without being in new record, this is how I know it's not because I'm typing in find) I type in the bridal couple's details and then perform a script that will take me over to the Bridal List. I use the unique number to recall related information(name etc.) and then I type in the list. Say I do this 3 times, and create 3 new lists. It has happened that I've had to go back to Bridal Couple and try to locate the first record that I've entered and it is now gone. (I haven't left the terminal, so no one has deleted the original on me) The other 2 records I've entered are still there. I go back to Bridal List and can recall the missing couple by using the unique number, and the list will come up in Bridal List, but only the information that Bridal List needs. So the information has been correctly entered and everything, it's just now gone from the original file. This also doesn't happen all the time, and I'm often imputing multiple lists (so it's not because I'm exiting out incorrectly). It has happened 3 times in the last 2 months, so what could be causing it? At first I thought it was someone else, or something I did, but the last time (the one I just described) totally negates all of that. Could it be because the parent file has become corrupted and needs to be reinstalled? Please help!

thanks, I'll try that too.

Thanks I'll try it!

Thanks but if the person who updates the product number file totally deletes the file and then imports the new file from excel, wouldn't the images go too? Or are you saying that the images are protected because the they are not actually in the file itself, just referenced there?

I work in a store, and we use FM to create bridal registry lists. I would like to add pictures to this list. But I want to create it so that every time I type in the product number, the photo pops up. However I can't just attach the photo directly to the product number, because each week that information is purged and then an excel file is imported into it so that the list remains current. So I would have to recreate the photo's each time. Is there anyway I can create another file that can attach itself through a relationship instead?

I'm having a similar problem... I'm using FM 4.0 & have a database that is broken into different script parts, first part is the client details, there are other scripts that are used for creating lists, purchases, letter writing etc. All other scripts need the client details script to access information to record product, purchases, correspondence etc. To start a new client, I must first start in new record so that I can be given a unique client number for each new record. Once that is done I go into the other scripts to create a list of product that is wanted or into another script to record what product has been purchased. I use the unique client number to access client details in related fields. I have noticed that in the past month, I have been losing client records. I know that the information has been correctly entered because I wouldn't be able to get that unique client number that is needed in the other scripts. I know that no one else is deleting the scripts because this sometimes happens while I'm still in the system working on other accounts, or even when I'm working on the same account, it retrieves the information into the list script and when I jump back to the client script the record is gone. The information stays in the other scripts, it's just erased from the original and the unique number is missing and cannot be pulled up. Is that a hicup? If I re-install filemaker will I loose all the records that I currently have? What can I do?