Jump to content

Repeating related records


etalentweb
 Share

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

Recommended Posts

Please refer to my relationship diagram.

I'll just talk about one field whose records I want to repeat. If I can make one work, then I'm Rn my way. refer to the upper left-most table, specifically the Well field, or in Filemaker speak, "[Wells].[Well]" and to the second table from the left, specifically [Royalties].[OwnerId].

The [Wells].[Well] field should appear as many times as the related field [Royalties][.[OwnerId] equals a given number, say "1."

Next I want to limit records to those created today or since a certain date, but I'll worry about that later.

I've made the layout's table [Royalties] and the portal's table [Wells], but it won't work. I've tried to follow the online help. I've been trying different things since sunrise. It's getting dark now. I'm cracking up.

Please help!

Thanks,

-Dave

Link to comment
Share on other sites

Hmm, the relationship doesn't really allow that. Based on the Royalty table, you'll only be able to see the one parent Well.

Perhaps if you based the layout on the Owner table you'd get what you're looking for (you'd see each Well that's associated with that Owner's Royalties).

Link to comment
Share on other sites

This topic is 5650 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
 Share

×
×
  • Create New...

Important Information

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