Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5077 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hi Everyone-

Im new to the forum and to Filemaker. I've read many posts on here which have really helped me but Im stuck on this one. Im hoping I can get some help from you all, please forgive me for I am just learning this program.

This is what I want to do:

I want create a material requisition form for work. It really doesnt need to be that complicated. I have put in the order number, current date, due date, and customer name which will all be entered each time I need the form since we dont manage our customers on FM. Thats all fine but I run into a problem trying to create line items for the different materials I need for that particular order. I've attempted to create a related table and create the line items though the portal but I get the error "This field cannot be modified until <fieldname> if given a valid value" everytime I try to create a record. I have a vague understanding of why this occurs but since I am inexperienced with databases and FM I have no idea how to fix it.

I imagine that what I am trying to attempt isn't at all difficult for anyone with experience so Im hoping you all can show me the light. (screenshot attached)

I appreciate any help I can get

Thanks,

Lee

fm help.jpg

Posted

It looks like your relationship is not set up right. It should be:

Orders::OrderID = LineItems::OrderID

See also:

http://fmforums.com/forum/showpost.php?post/309136/

This topic is 5077 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.