Many to Many too Many...
I've searched through the QB discussions and couldn't find a good example of creating a many to many relationship where I can select records from the same table. I have the relationship working from one table to another and visa versa but I'm stuck now when trying to pull a record from the same table (see attached). Here's an example of what I'm trying to do... I have one table named Guests and a second table called NonGuests. Both have a relationship setup to a third table called, "Related Guests". The Guests will have either family members, friends, etc... who are NonGuests. But, there are Guests who have family, friends, etc... that are also Guests. The issue I'm having is, when I create a Related Guest I need to pull a record from the same table because there are Guests who are related to other Guests. Am I overlooking the obvious? Any suggestions would be great as from what I've read you shouldn't create relationships with "Guests with many Guests". Thanks!7Views0likes1CommentPassing fields from Child to Parent
Hi, I have two related tables: Request Table and a Requisition Table. The workflow is to enter the Request information first. Then from the Request table, click on the Add Requisition button to add the Requisition information. This is working as expected. When a Requisition is added from the Request form, the # of Requisition records summary field is updated correctly. What I am needing help with is passing the associated Requisition number into a field in the Requests report. Currently the # of Requisition records summary field shows on the Request report. But the Related Requisition Number or Related Requisition does not show in the report. I have to go to the Requisition Table itself, and then manually link the related Request to the Requisition. I hope this all makes sense. It is difficult to explain. Thank you in advance for your assistance.14Views0likes0CommentsFilter out some records on related table
I have two tables one called Provider records and one called descriptions. The Provider is the child and the descriptions is the parent. The descrition table has two fields named Record Type and Record Description. There is one Record Type/Description combination that I don't want to appear in the drop down list on the form but I can't seem to hide it. The user picks the Record Type 1st and in a second field is presented with a list of desriptions that match the chosen record type. In the related description field on the form, I changed it from record picker report to another embeded report and I filtered that embeded report to not include the description that I no long want showing in the drop down but it's still there. What am I doing wrong?Solved19Views0likes3CommentsRollup Help
I've added a new Parent table "Cases" table to my already-established Child "Call Records" table as suggested to me earlier this week, and created a bunch of roll-up fields so that our end users can enter their fields on their call, and it will roll up to the master Cases into summary fields. Previously, we delineated calls that were subsequent calls of a same case utilizing a field on the call record ("Continuation of Earlier Case"), but it created issues of duplicate data. That said, two questions: Is there any way to create such summary but filter out answers = to "Unknown" or "Not reported", unless they are theonlyanswer? I suppose the alternative is simply to have no answer. We've used Unknown/Not Reported on multi-select text fields for the ability to require the field nonetheless, but if on a subsequent call, the data is known, I'd like to disregard "Unknowns". Can I use the roll-ups to tie to another Parent table? I'd like to tie all these to the hospitals that call us. But in theory, it could one day be more than one hospital (e.g. patient transfers, two hospitals call us). I have a summary of hospitals, which today is universally one hospital deep -- but again, within the realm of possibility to be more one day. These Case roll-up fields will power a lot of analytics that were on our Call Records previously - demographics of cases, etc., so a lot of variety in the static items creates another issue with data clarity/cleanup. Thanks!36Views0likes5CommentsQuestion about relationships
Hi there. I'm new to Quickbase and trying to learn as I go. I'm building some tables for our company and need help with the relationship between customers and their orders. I apologise if this has been asked countless times - if someone can point me to the right answer I'd be very grateful. Our company has many customers - and I've created a 'customer info' table to store their information (company name, contact info, website, phone, email, address etc). These customers can place lots of orders with us. So my second table is an 'order sheet' which has details of what they've ordered, when it's needed by, what size it is, its weight - that sort of thing. On this 'order sheet' table, I would like to have some of the customer info (company, contact name and phone number). I'd ideally like it if, when the customer name is selected from a drop-down (or similar) then their phone number, contact name and email is automatically populated. Is that possible? As a follow-up, if it is possible, and once the relationship is properly defined, can I select a customer from the 'customer info' table and then show a list of everything they've ordered? Would that require a new table? Thanks in advance if anyone can help (especially if it's explained as simply as possible!) Simon.21Views0likes1CommentQuickbase Actions
I am trying to make a Quickbase action... When a certain action takes place, I would like for a field to be edited, rather than having a new record created. However, the option for a field to be edited is blurred out. I need the field in another table to be edited? What am I missing?53Views0likes5CommentsRe-establishing relationships in migrated databases
I need to understand how to re-establish relationships on existing tables that I have migrated into Quickbase. I know am absolutely missingsomething that is probably pretty obvious. Its an MSAccess database, so its SQL compliant. I have a table with important information in a field that I want to preserve. This is the field in the child table--lets call the field BigInfoValue (a numeric field) and the table ChildTable. I have a tiny table with other information in it that defines what the values in BigInfoValue mean. Lets call this BigInfoParent table, and lets call the fields BigInfoValue (a numeric field I want to relate the tables on which I've also designated the key field), BigInfoTerm, and BigInfoDefinition. I absolutely cannot figure out how to make the two tables link on BigInfoValue. When I try to create a table relationship, with BigInfoParent, Quickbase does not offer me BigInfoValue in the child table as a linking field. It creates a brand-new field called Related BigInfo something something. I've also tried to establish a table relationship with the RecordID field in BigInfoParent to BigInfoValue in the ChildTable. No dice. Quickbase just doesn't offer me the field that I think should be linked. Any help would be appreciated.19Views0likes1CommentSame reference field, different selections within the form
I have a scenario where I have a parent table with a list of trial numbers. I have a related table that has a list of subjects. Each trial has many subjects, and some subjects have more than one trial. In my form, I want to be able to add a new subject. In one field, I have labeled the primary trial, which is a table relationship picker. However, I also want to have a second field labeled the secondary trial, which would pick from the same table as the primary trial did, but with different results. How do I make the referenced selector independent of one another?Solved28Views0likes2CommentsFilter records based on table connection
Not sure if the title exactly describes what I am trying to achieve, but here is what I'm working on. I am trying to create a simple-ish application for one of my teams where they can track projects, enter associated time entries for each and then create invoices for those entries. My setup is Customers table, Projects table, Time Entries table, and Invoices table. Customers relates to Projects and Invoices (1 Customer can have many Projects and Invoices). Projects relates to Time Entries and Invoices (1 Project can have many Time Entries and many Invoices). Invoices relates to Time Entries (1 Invoice can have many Time Entries). What I'd like to have happen is when a user goes to create a new Invoice, they would select a Customer and then a Project and then see a list of Time Entries where Customer and Project match AND the value in the Related Invoice field is blank (i.e. Time Entries that have not been previously invoices). The thinking is that the user would then be able to select all the Time Entries they wanted to have included on the new Invoice and then the Related Invoice field for those Time Entries would be updated with the newly created Invoice. Is something like this possible?Solved43Views0likes1CommentBi-Directional Data?
Hey everybody! I have a form I created to keep track of inventory in our IT room named "hardware". I have another form I created when issuing equipment (new assignments). New assignments allows me to search the user by employee ID number (that's pulled from another table called employees), and then i have a lookup field that brings up the details of the equipment when I search by serial number. One of the details it pulls is the "hardware status" that can be several predefined options like "in stock" or "Issued". I have a checkbox on the form new assignments, that when checked and the form saved, I would like it to automatically update the field from "In Stock" to "Issued" in the hardware table. Is this possible? Where can I find documentation on how to do this? Thanks! Leo. ------------------------------ Leo Matute ------------------------------Solved17Views0likes3Comments