ContributionsMost RecentMost LikesSolutionsHow do I create a BOM for an assembly that relates to Part#sI have [Assemblies] and [Parts], I need each assembly to have a list of parts that it requires, but I also need to be able to relate each part to multiple assemblies. I know this will be a reverse relationship situation, but I'm struggling with how to get it done. Can anyone offer a breakdown for me? Thanks.Re: Create a record in different table every time a specific field value is unique?Yes, I have figured out how to add the record automatically in the shipments table, But I need to be able to add the record ONLY when the "ordered item" record's "due date" field is a date that another "ordered item" record doesn't currently have. For example, Item #1 due date = "10/10/2020" Item #2 due date = "10/10/2020" Item #3 due date = "11/12/2020" Item #4 due date = "12/15/2020" There should only be 3 shipment records auto-generated to match the due dates that are unique, because Lines 1 & 2 are the same due date and can be shipped together as one shipment. Any way to check for unique dates before auto-generating a record in the shipments table with the corresponding due date? ThanksCreate a record in different table every time a specific field value is unique?I have an Orders table and a Ordered Items table. I would like for every time a new item record is added, if the due date doesn't match any other records' due dates, then a new record needs to be created in a Shipments table. In essence, if all items are due on the same date, they should all be on the same shipment. If there are multiple dates, shipments should only be created for the unique dates. Can this be done in QB? Thanks for any help!Re: Trouble comparing number values in formula fieldOkay, so at the moment I think it seems to be working. Not 100% sure what the problem was but I deleted all formulas and re-wrote everything. The only thing that might have thrown it last time is I'm not sure if I was rounding the Quantity field to .01 which I am doing now so that its not 5x$2.99, it is 5.00 x $2.99. Don't know why this would matter since I was already rounding both numbers in the final check?? If it throws any more errors I will try converting to text. Thanks for your help!Re: Trouble comparing number values in formula fieldYes, I currently have that exact formula in place and occasionally get a matching value but 99% of the time even when the values are the same, it still checks are not equal. Re: Multiple choice list narrowed by selected company?Okay, thanks for your help! I finally got that part working. The next step up is more complicated. I need to have a purchase order with multiple line items attached. Then I need to be able to create a shipment that has attached parts from a selection of the line items from the purchase order. Been working on it for two days and cant wrap my head around the relationship logic. I know it is going to be a conditional drop-down but its difficult because I need the line items to only have one complimenting attached part. Puchase Order --------> Line items | | | | | | V | Shipment | | | | | | | V | Attached Parts <--------------- I am struggling with Quickbase. I am used to writing direct functions with PHP or ASP.net and this is proving difficult to learn. :$ Multiple choice list narrowed by selected company?I have orders form where a user can select a business. I would like the 'business contact' field to be a multiple choice of only the contacts within that specific business. New Order--> Business Name: Business 1 Business Contact: ----> Contact 1 ---> Contact 2 ----> Contact 3 I just cant figure out how to link it all to work right. Thanks