bubette

Hi Walter, Thanks for replying. I wish I were a more experienced user so that I could take advantage of your information. What sort of scripted solution would I use to submit a record?

Hi Inky Thanks for replying. I'm just not sure about adding a new layout just for new records. Sounds a bit confusing. Does anyone else know if there is a field option that will permit what I'm trying to accomplish? Thank you to everyone for your help.

I'd like to have field contents locked, after they are created, but still be able to add a new record and enter new information into this same field. Is this possible?

Thank you everyone for your help. I was just going to ask the question about doing a date search when I noticed that David had already answered it. from an appreciative novice

Hi Ender, Thanks again for replying. I did try that. I've enclosed a jpeg of the choices that I made. Then I received an "error" message. I've also enclosed a jpeg of that. Should I have that extra duplicate table?

I just thought of something: I'm having difficulty entering new information into the 3 fields (comment, date and weight) that are part of the clinical table. I need to edit the relationship to allow the creation of records, (in this table via this relationship) but I'm not sure how to do that. Is there anyone that could help me?

Sorry. With all of the problems I was experiencing I may have lost sight of specific problems. In the clinical data table, I can seem to enter new data.

I've enclosed a clone of the data base that I was working on. I ended up doing another recovery on the recovered file. Then I saved a clone of that. The file is now veeerrrry slow. Also, it wouldn't let me add more comments to the clinical data file. If someone could take a look at it, I would really appreciate it. Thank you. _Clone.fp7.zip

My recovered file is now experiencing the same problems that I discussed above. Those 2 messages about unique values and not modifiable keep popping up when I try to get out of the record. I can't even close it. I'll have to force the program to quit. Is there a way to send a FMP file without the data? Then it wouldn't be as big and I could send it.

Thank you so much for your help. I've enclosed a zipped file. Okay, I tried to send the file and it's too big. Upon working something out, so that I could send you a smaller file, I decided to do a file recovery on the messed up file. Lo and behold, lots of blocks of data were recovered and it now works that way it should. Yeah!!! I'm so happy! I was prepared to redo the entire 90 bird records. One question, how do I do a range search, for example, find all of the records for 2005? I know that I can't just type in 2005 in the date field. The information doesn't seem to be in HELP file.

Sorry Peter, the story is not getting any better. Unfortunately I seem to be learning the very hard way. I made some changes, again to try and correct previous mistakes. Now I'm getting the messages above and can't open the database to fix it. Can't make new records either. :)

Hi Peter, Thank you for the explanation. No, it wasn't too long. But I think I made a mistake. I deleted some fields and now I can no longer enter data into the portal fields I have for the layout clinical data. I've enclosed some jpegs to try to clarify my problem. I have that you can read them. Bubette

Hi Peter, That you for returning such quick help. The record number symbol is '@@' . I understand how the number changes, depending on the position of the record so, you're right, it doesn't need to be the same as the ID. "The ID field should be used to uniquely identify a certain record. Normally, it wouldn't even be visible to the user." How would I make that field and the number it contains invisible to the viewer? "Duplicates should NEVER be allowed, therefore, you should check the "Prohibit modification ..." checkbox in the auto-enter menu and uncheck "allow user to override..." in the validation menu." The ID field, which is a number Type, now has these options: indexed, auto-enter serial, Can't Modify Auto, Required Value, Unique, Numeric Only. Could you explain the option, for Auto-Enter, Serial number is checked, Generate On Creation, next value ______. Where does the number, that is in the next value, come from? Thanks again for your help. Bubette

I have created a database of 90 records. On the top of each record I have a record number symbol. Also on each record I have an ID field. Its options are: indexed, auto-enter serial, required value, unique, numeric only, allow override. When I initially planned the database, these two numbers were synchronized, so that the Id field was the same as the record number. Since then, I've added more records. Now they are no longer the same. Sometimes 2 records have the same ID number, which means that one record will have incorrect information in the portal fields. I think that I may have chosen incorrect options for the ID field, but I'm not sure how to change it so that I don't have duplicate ID fields and incorrect data in the portal. I would greatly appreciate any assistance you could give me. Thank you.

I would like to link 2 diffent data base files using a button. Is this possible? Thanks for your help. FileMaker Version: 6 Platform: Mac OS X Panther

I'm copying the data from other sites. In Browse Mode, when this data is pasted, it doesn't conform to the style I chose in Layout Mode. FileMaker Version: 6 Platform: Mac OS X Panther

While in Browse Mode, is there any way to select and format several fields at once, giving all of them the same font and size? FileMaker Version: 6 Platform: Mac OS X Panther

Your knowledge of FM Pro is obviously much greater than mine. How would I script switching between layouts and disallow the use of the layout menu?

I have one file, with 2 different layouts. I would like to hide certain records from layout one, but would like to see these records in layout 2. When I try this, the records disappears from both layouts. Can this be done? Thanks for your help. Bubette FileMaker Version: 6 Platform: Mac OS X Panther