Drop Down List just doesn't work

[Greg Di]

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

[IdealData]

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.

[Greg Di]

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