By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,706 Members | 1,298 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,706 IT Pros & Developers. It's quick & easy.

measurements

lee123
100+
P: 556
is there a way to put measurements on a form or a query if so how would you do it.
May 28 '07 #1
Share this Question
Share on Google+
2 Replies

lee123
100+
P: 556
I mean cooking measurements
May 28 '07 #2

nico5038
Expert 2.5K+
P: 3,072
Basically you'll need to think of a way how to record these measurements in your database tabel.
For cooking instructions I can imagine that you have a limited set of measurements like "spoon", "kilo", etc.
Now add to the ingredients tabel (tblIngredients):
Ingedient
Quantity
Measurement

and use a tblMeasurements to hold the allowed values. When you use the lookup tab in the tblIngredients on the measurements field, you can make a combo for the field looking up the measurement from the tblMeasurements.

Clear ?

Nic;o)
May 28 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.