VLOOK-UP (relationschip)
I’ve made in QB a table, where we can search on a specific code and he will give the other related masterdata (out of backtable). Problem statement: The problem here is , he can only work with 1 code (80737797) - to reflect the related masterdata, so in case we have multiple codes , we are currently not able to reflect all the codes via this way. So in this case , Code 80748492 & 80830493 aren’t able to be reflected via the “Related masterdata”-fields. Is there any potential way to have this done within the same “record ID / Line” ? Is there any other opportunity to have the same outcome , but with another workaround. I know we can go for multiple record ID’s. But this I would like to avoid as it will create confusion for our partners. Many thanks !
I need help creating a snapshot field in a unique parent-child relationship.
In my app, there is a relationship between two tables, call them Table A and B. In table A, there is a column called batch date. For this field, we would like to create a new field based off of it called initial batch date in the same table. This would essentially be the first value that was inputted in the batch date field (that field has end users inputting a value often). From the research I have done, the best way to preserve original values is using a snapshot field. From what I understand all I have to do is add a lookup field to the child table, then create a new field for a snapshot that effectively references this lookup field. The problem is in this relationship, table A is the parent and table B is the child. How would I create a snapshot field for table A in this situation? So far I added the lookup field in table B, then I created the snapshot there, and then added it as a summary field in table A to reference the original snapshot. This did not seem to give the desired result. Any suggestions? Open to anything. Sorry if it is not super clear as I am only a few months experienced in QB. Thanks,
Child Table Field Question
I have a table called "Crane Inspections" that is the child table of a table called "Open Crane Deficiencies". I am trying to have a way to put in deficiencies (up to 4 in one form) that are either existing (noted on previous inspections and still an issue) or new. On the crane inspection form, a crane is selected from a multiple choice field, 23 different questions are completed, then deficiencies (existing or new) are annotated at the bottom. I have a way that this works now, but I am trying to make better. Right now, I have a pipeline that triggers when a new crane deficiency is put in the form (also up to 4 new ones) and creates open deficiency records in that parent Open Crane Deficiencies table. Our maintenance department goes and works on correcting the deficiency, then closes it out which deletes the record from that table. Meanwhile, on the crane inspection form, that previous open deficiency option will no longer be one on the existing crane deficiencies multiple choice field (the table-to-table relationship field). My more ideal end state is rather than have to manually select up to 4 existing deficiencies every time an inspection is completed, I would like for the up to 4 fields to be automatically populated with the existing deficiencies from the parent table. Then some way for the inspector to confirm those are still deficiencies, or enter new ones in as I have before. Please let me know if there is any clarification needed. Any help would be greatly appreciated!Can you summarize a status for a record that has multiple child records?
I have a parent table (Requests) and a child table (Activity Log) - each Request can have multiple Activities. I am trying to get a summary of the Status logged in each activity to get an understanding of the current status of the Overall Request.
Limit Relationship Choices based on another field..
So I have a table, Purchase Orders. That table is a one to many child of Jobs. It's also a one to many relationship of Daily Reports. Daily Reports is also a child of Jobs. What I want is for user A to login, and enter 5 POs, and link them to Jobs. Then, user B logs in and clicks the "Related Daily Report" field and it's limited to ONLY the jobs selected by user A. Is this possible?
Relating Multiple Records from another table
I am trying to create a new process for tracking manual revisions in our training curricula that we've built into our project manager app. Each change may affect multiple curricula, and multiple lessons within it. I would like to be able to add a change, select the curricula it applies to from a dropdown, and then have another dropdown of lessons from the curricula. I have the relationships set up the way I want it now, but I can only select one curricula and one lesson to relate to each change record. I've seen the many to many option of having a table in the middle, but I'm struggling to figure out how to apply that to my scenario. I remember an Empower session that related multiple work equipment to one work order using a multi select and a Pipeline to relate that to an Equipment table but I can't remember how it was done in the end. I'd love any ideas!
Inventory Tracking
I have these tables: Trailer Trailer Inventory Item Item Usage Currently my structure is set up like this: Each Trailer has many Trailer Inventory records Each Trailer Inventory has many Item Usage records Each item has many Item Usage records Each Item has many Trailer Inventory records This is what I am trying to do: Enter in an item usage record and subtract from Trailer Inventory. When the item usage record is entered, I know the Trailer ID & The Item ID. I need these two IDs to match to a record in the Trailer Inventory table and subtract the quantity used from the Starting Quantity in that line. Example: In Trailer Inventory, I know that my starting quantity for Item #1 on Trailer #1 is 10. I then go enter in an item usage record and I enter that I am using Item #1 on Trailer #1, and I'm using 5 of them. I want that to go match up to the Trailer Inventory record using those two IDs, and subtract the 5 used from the original 10 that we started with. I have a summary field on the relationship between Trailer Inventory & Item Usage that summarizes the "quantity used" from the item usage table. I was trying to add criteria to this summary field to say only summarize the records where the Trailer ID & the Item ID match on both tables, but I can't seem to get it to pull in the correct fields in the drop downs so I don't think my connections are set up properly. Can anyone help with this?
