timothy.corbin
Registered User.
- Local time
- Yesterday, 22:50
- Joined
- Apr 24, 2019
- Messages
- 11
I am wondering if a thing is possible, and if so where I can read up on how to achieve this.
A form feeds a table. The form has two quantity fields: Weight or Units, which represent either how many of an item have been thrown away OR how much by weight. The FBI already "knows" that HERB SAGE is sold by individual units (EA) and APPLE GALA is sold by weight (WT).
Is it possible to have ONE quantity field on the form, and when the user inputs this quantity the DB recognizes that it is either a EA or WT number then directs that data to the correct field on a table?
The attached db isn't the most updated. I have it set now so that it exports the salvage data for excel, and auto populates the unit price on the data entry form based on the item selected.
Yall have helped me immensely, and I keep learning!
A form feeds a table. The form has two quantity fields: Weight or Units, which represent either how many of an item have been thrown away OR how much by weight. The FBI already "knows" that HERB SAGE is sold by individual units (EA) and APPLE GALA is sold by weight (WT).
Is it possible to have ONE quantity field on the form, and when the user inputs this quantity the DB recognizes that it is either a EA or WT number then directs that data to the correct field on a table?
The attached db isn't the most updated. I have it set now so that it exports the salvage data for excel, and auto populates the unit price on the data entry form based on the item selected.
Yall have helped me immensely, and I keep learning!
Attachments
Last edited: