Jump to content

Autoupdating Assemblies


sparky3903
 Share

This topic is 2870 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi group,

I have an estimating db that I have a table for items and one for assemblies and one for assemblyItems. The assemblies are like a header table where I have a title of the assembly and I add items from my items table into my assemblyItems table. This creates a actual cost for the assembly. So an example is this; (I am an electrical contractor)

Office with 2 Lights, 1 Switch and 3 Receptacles. $328.00 4 hours of labour.

This has the following items in the AssemblyItems table that will make up the cost of the assembly.

2 2x4 Troffers c/w lamps $68.00 2.4 hours of labour.

1 Box $4.00 .02 hours of labour

Wire, etc....

I would like it so if I update a price in my item list the linked item in my AssemblyItems table is updated and the assembly header is updated.

What do you think Is the best approach for auto updating, something that won't kill the speed of the db.

Thx,..

Jamie Lindemann

Link to comment
Share on other sites

This topic is 2870 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.