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

Adding Related records for one to many


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

Recommended Posts

Posted

In my master file I have a layout that is all fields from a related table, but the fields are not in a portal. I don't want to display all related records I just want to add new ones. The relationship is a One to Many using the A Serial Number Field. I am tring to add multiple records to the related table. If I enter data into the related fields it stores the record but how do I create a second record for the same Serial Number with out leaving the Master file. Do I need a portal?

Posted

Well, a portal makes it easier to view this info and add records, but its not necessary. Did you check "Allow creation of related records" in the relationship definition?

BTW, If I am not using a portal, I find it a little neater to always create records in the related db. You can have a script go to a layout and create rec in the related db. Thats just me.

Ken

Posted

Well I am not sure how to make this work. I have a on to many relationship layout that is not a portal. I don't want to show all the related records. I want to either display one record based on the serial number and machine number. I have that working, but I also want to be able to add a related record. I keep getting the relationship is not valid and needs to be corrected, but I have recreated it and it has "allow creation of related records". Is there a script step for creating related records? If I use create record it creates a new record in the master file.

This topic is 8177 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.