Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I suggest that you take a step back from the �weeds� and make a diagram on paper of your tables and relationships and post that. There is no sense floundering and guessing until you get the architecture correct.
Please read my post again,especially the parts where I said that you need this setup
�One Estimate has Many Material Estimate Lines.
One Material Master has Many Material Master Lines.
So you will need to make a new table for Estimates and also a new table for what is called the join table which are the Material Estimate line items on the Estimate.�
I don�t believe that you made the table called Material Estimate Line Items.
These are like what you would see on any invoice
One invoice has Many invoice line items
One Item Master has Many Invoice line Items.
Post back with your progress or contact me directly to get you over this hump. I�m at QuickBaseCoach.com.
Please read my post again,especially the parts where I said that you need this setup
�One Estimate has Many Material Estimate Lines.
One Material Master has Many Material Master Lines.
So you will need to make a new table for Estimates and also a new table for what is called the join table which are the Material Estimate line items on the Estimate.�
I don�t believe that you made the table called Material Estimate Line Items.
These are like what you would see on any invoice
One invoice has Many invoice line items
One Item Master has Many Invoice line Items.
Post back with your progress or contact me directly to get you over this hump. I�m at QuickBaseCoach.com.