If you reply back to you earlier post, you can continue the discussion of your project without having to redescribe the basic issue each time.
Please post your calculation. I don't see why your calculation is counting a sick day even though you are "deleting the information". And how are you deleting this informaiton? Are you deleting the entire related record or clearing a field?
I think the issue is that I am simply clearing a field. The calculations are showing that a sick day is taken because by putting information into the portal field, it is creating a record in my related file. Thereby automatically saying there is a day taken. How can I delete a related record while in the Master file?
Sorry the calculations for my Related file are below:
Hours Out Sick = If(Time Out ≤ Begin Work,"6.75",If(Time Out ≤ TextToTime("2:15:00 PM"),(((End Work - Time Out)/3600)-1.25),((End Work - Time Out)/3600)))
Begin Work = TextToTime("9:00:00 AM")
End Work = TextToTime("5:00:00 PM")
Do you have a portal to the related records?
- If so, double click the portal while in layout mode to open portal setup...
- Enable the "Allow deletion of portal records" option.
- Adjust the size of your portal to make room for a small button you put inside the portal row and set it up to perform the step: "Delete portal row".
- When you delete the portal row, you are deleting the related record in the other file.
Ok I did that and it deleted the client from my master file....
And now becauase I have to enter the information again the serial number employee ID is saying that we are a few ahead...
The button should be fully inside the portal, not on the layout.
You can open up define fields, find your employeeID and update the next serial number setting before trying again to create the new employee record. (On the other hand, no harm is done by being a number or two ahead in the series, this value is simply a unique identifier.)
I have checked that it is fully inside the portal line and it is still deleting the Employee rather than just the one related record.
I have checked the button is set to "delete portal row"... Maybe I have something wrong with the way my portal is set up?
What option did you select for the button?
Don't see any way to mess up the portal setup, but you do need to be careful to make sure your relationship is linking to the other file and not linking to the Master File here.
Oh, one other thing to check. In your relationship from the new related file to the master file, make sure that you didn't enable the option that deletes the employee record everytime you delete a record in the new file. Open the related file, go to define relationships and make sure that "When deleting a record in this file, also delete related records" is not selected. (Note: I don't have a copy of FileMaker 6, but do have a copy for 5.5. I'm hoping version 6 has the same dialog here that 5.5 does. You may find some differences.)
FIXED! Thank you Phil!!!!
Just as you said, I had the "when deleting a record in this file, also delete related records" selected in my related file.
Thank you a million times over!
New question about this Version 6 software.
I have a few pdf documents that I would like to add into my records. When I do a 'container' field and then right click I get the options to "insert picture', "insert quicktime" or "record sound".
Is there a way of inserting a pdf to view from that page or to just reference it?
Sounds like you should upgrade as this is not easy to do in your version.
Insert Picture may work, you'll have to try it and see.
You might be able to store the filename and file path in a text field and use Open URL to open the file.
I seem to remember from FM6 that insert quicktime would work for pdf files too. You won't be able to view it from filemaker, but using the open URL Phil described should get it to open.
Ok. Thank you both. I can insert a pdf by either picture or quicktime. The Quicktime then shows the many pages as though it were a video. The picture just shows the pdf. Unfortunately there either is not, or I cannot find, a way to 'Open URL' to open the file. No matter.
Phil, I definitely agree with you that it is time we upgrade, unfortunately it is not my decision but the company's. :)
One more question: I have a related field with a drop down value list in my related file. I have that related field in a portal in my master file. However, when i am in the master file, I do not have that option of a drop down value list. Do I have to input the data in the master file or is there a way to link those value lists?