Drop Down List just doesn't work

March 4, 200916 yr

Newbies

Hi all,

I am not a database programmer, but I am a computer person in general.

I am working on building a simple (at least I think so) estimating database for my construction company.

Basically, I want to keep an Inventory list of frequently used building components that also has a price for each item. This part is easy and I think I have that table and form nailed.

Then want to build an Estimate Form where I can can categorize the various parts of a job with a static heading. Under the heading, I would have Drop Downs that I can select my items from, enter in a quantity and have the Estimate Form calculate all the final price. I would also like to have a field to hold a markup value (or even a couple) to calculate say a 10% markup, a 15% markup, a 20% markup, etc...

The issue I am having is that I built a Value List based on my Item Inventory. When I add a new Drop Down field onto my estimate form, all of the setup dialogue boxes look OK to me, but when I Exit the Edit mode, the dropdown field is dead.

I am at a complete loss. Perhaps my relationships are wrong? Maybe I screwed up? I honestly don't know.

I bought the Missing Manual book and have been following it religiously, but I'm stuck.

I am attaching my lowly database. Maybe someone can take a peek and let me know where I went wrong?

Much appreciated.

If anyone needs construction advice, I can at least give you that! :

2009_Deck_Estimating.fp7.zip

March 4, 200916 yr

Assuming your ESTIMATES table is supposed to be composed of many records that base themselves on an original ITEM, then you have an essential field missing from your ESTIMATE table - namely "ItemID"

Create that and substitute it for the ::ItemId on your layout.

March 4, 200916 yr

Author
Newbies

Thanks for that tidbit! It moved me ahead somewhat. At least I have info on the page now.

I've reattached my db because I think I'm close.

I've put some notes on the Estimate layout to explain what I want to do. If it's easier to just manipulate my file and reattach it, by all means go ahead!

Hopefully, there is light at the end of the tunnel!

2009_Deck_Estimating.fp7.zip