ContributionsMost RecentMost LikesSolutionsRe: Is it possible to export entire app ?I am interested in doing the same thing. Our company is closing, so it's not as though we are moving to another competitor. I would like to export the app structure/dynamic form rules so that I can someday re-launch a Quickbase account for a similar business and not have to start from scratch. Is this possible?Re: How to relate many records to many other records in the same table?I'm confused... That's how the buttons are already set up. I have a rule on the Accounts form to show/hide one of the buttons based on whether the Account Record is an artist or a gallery.Re: How to relate many records to many other records in the same table?Yup! Related Artist - 8 Related Gallery - 6Re: How to relate many records to many other records in the same table?Sure, here is the formula for the "Add Artist" button: URLRoot() & "db/" & [_DBID_ACCOUNT_ASSOCIATIONS] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Record ID#])& "&z=" & Rurl()Re: How to relate many records to many other records in the same table?That's correct -- There is one field for Account Name on the Accounts table. What I mean by auto-populating -- I begin on the Accounts record for "Yancey Richardson Gallery" and click the button to "add an artist". This takes me to the form, where there is the "Related Gallery" and "Related Artist" fields. Each dropdown has it's custom record picker, which correctly filters, but when you arrive at the form the account name is filled in for "Related Artist" while "Related Gallery" says "Make a selection..." So it's somehow forcing whatever account record you started on in into the "Related Artist" category.Re: How to relate many records to many other records in the same table?That issue is resolved, but now I have a new one! The form for setting up the gallery-artist connection is always autopopulating the "related artist" field with the account name, even if it's a gallery. See screenshot. I don't even care if you have to reselect the gallery in "Related Gallery", I am just concerned it will cause confusion when it appears as "Related Artist." Re: How to relate many records to many other records in the same table?Wow, this makes total sense and is technically working, so thank you! The only hiccup is that I can't get the embedded report to show the related gallery/artist after it is added. I can find the record in the new table, though, so I know it's been successfully created. I checked the field properties for the report on the accounts form, and it's filtering the report by matching Record ID# to the [Related Gallery] or [Related Artist] appropriately. Is there any other reason it may not be showing up on the account record?Re: How to Link to Related Records in Same TableOk thank you! I just posted:https://community.quickbase.com/quickbase/topics/how-to-relate-many-records-to-many-other-records-in...How to relate many records to many other records in the same table?I have a table called "Accounts" where we store all of our customer data for order tracking and invoicing. Some accounts are individual artists and some are art galleries. Here's my issue: We need to be able to show a table on gallery records listing the artists we work with represented there, and a table on the artist records showing their respective galleries. I related the Accounts table to itself but because it's a one-to-many relationship, I am either limited to one artist per gallery, or one gallery per artist, depending upon which record I start with.... I don't just want to create multiple relationships, since it looks wonky and there isn't a set number of artists or galleries that may be associated with the other.... Is it even possible to relate many records to many other records in a single table?Re: How to Link to Related Records in Same TableI am trying to do the same thing... but both records have to be edited to establish a mutual connection. Has anyone figured out a way to make both records relate to one another simultaneously?