Jump to content

relationships and repeating text fields


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

Recommended Posts

can someone explain whether or not this is possible.

I need to represent the following heirarchy in my files.

ok an Item belongs to a series and a series belongs to a collection. no big deal, except that I have only two files in my database, an item file and a collection file. In the collection file there is a repeating text field that you enter the series titles.

currently in my Item file I can assign what collection an item belongs two via a relationship and a value list (drop down list) based on the contents of the collection file. I would like to also be able to assign a series (again a drop down list)in the item record but limit it to the series (basically list the contents of that repeating text field)that belong to the collection that is selected.

Is this possible without creating a series file and completely separating my series field from the collection file?? I really don't want the people that are using this database to have to open up another series file and join file just to define what the series are that are in a collection.

I guess im curious whether or not information entered in a repeating text field is specific only to the record in which it was created?

did that make any sense at all??


Link to comment
Share on other sites

The portal belongs in the Item file and one of the items is Collection. The collection file should be a join file with two or perhaps three fields: parentID, ItemID, Type. An infinite hierarchy can be set up this way. See the FileMaker 5.5 Advanced Techniques book by Moyer/Bowers for an excellent example. No repeating fields are required and in general they should be avoided.

Link to comment
Share on other sites

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