Search results

Thank you, Mike. I'm sorry, my intention is to not hard-code any column. The sample Excel file serves just as a little demonstration that I may have different columns for different tasks. I really can't determine the number of columns or the names for them, this needs to be done on the spot...

I'm afraid I'm not understanding why keeping my customer's unit and its match in the same row is bad. If I understand you correctly, you say I need a table like this: fk | match 1 | pc 1 | pz 1 | pce 2 | sqmt 2 | m2 2 | mt2 ... Is that what you mean?

Thank you very much, Mike. I really appreciate the effort you put into capturing the initial vibe of the solution. There is, however, a problem in the concept. If you wouldn't mind, take a look at the Excel file attached in post #13. In it, the columns used for breaking down the total Kg for the...

Yeah, I mean, that's a combobox. But how do I actually make use of this for the breakdown?

Uh... is this what would make it work?

My breakdowns table should change, right?

I have arrived to that conclusion too. I need to match them. Now, assuming I match them, how would the schema have to look in order to "load" a sort of "template" for quantity breakdown for that unit?

Yes, and I need to express that in a database schema that, when reporting, I can see my data tabulated properly, with varying column names.

The problem is that when I charge my customers, I have to be transparent about how I arrived to a certain quantity. I will not show them a formula or the code that processes the columns. What I will show is values arranged in a tabular way, by columns. If I'm calculating surface area, they...

The remaining sections of the database handle pricing through a few dedicated workflows. To compute the total, it relies on the quantities supplied by the phase under discussion in this thread. Therefore, my focus is exclusively on a solution that adeptly and gracefully manages the breakdown of...

Please refer to my response to @GaP42 I'll be back in a few hours to keep adding info and reply to the other posts. Thank you everyone.

@GaP42 Hello, thanks for bringing that to my attention. I want to ensure clarity. In my tasks table, there's a foreign key (FK) linked to a task_groups table, which, in turn, has a FK connected to contract_details, and so on. The broader database structure is functioning well, with dedicated...

@CJ_London Not sure I understand this. Are those brick definitions? That would require that I have a hard-coded number of columns, I would like to explore a methodology that allows me to indicate only what each item in the breakdown would require. The methodology you refer to is definitely the...

Thanks for the warm welcome you all. ✌️✌️

re-reading this post made me realize I'm being very vague about some things What I mean by this is that my current idea of a schema only contemplates the hardcoded a, b, c and reps. I may need more. My header names within the form. That's what I mean, so I also need to account for this...

I build all kinds of stuff and I need to calculate the quantity of each task to charge my clients. Some tasks are measured by volume units, such as m3 (cubic meter, three dimensions multipled), others are measured by m2, others by kilogram (dimension x unit weight), others are simple, just a...

Hey fine members, been browsing this forum since 2015. Hope you're all well. I'm a humble 35 year old construction engineer with poor database skills, hope to improve with you all.