J
JMC
Any Help would be greatly appreciated
I seem to be having some difficulty with a continuous form that when you
enter new data the previous record will not show some data that was just
entered.
My database has 8 tables 7 tables are tables used by the form and one is the
feeder table from the form. The table is conceived to allow for an inventory
count using displays as the determining factor for what stock is actually
required.
The form is set up as follows:
Dealer number (Combo from one of the tables to insert a number to form)
Dealer Name (lookup box referring to the number just selected)
Report Date (simple entry field)
Fixture (Combo box allowing you to select from various fixtures in the store)
Hardware (Combo box allowing you to select specific hardware that would work
with the previously selected Fixture)
Category (Combo box allowing you to select from a group of predetermined
categories)
Item description (combo box that is dependant on the hardware selection
different hardware will give you different item descriptions)
Storage quantities, display quantities (these are simple data entry boxes)
Recommended stock (this box display an number associated with the Item
description record from the same table)
Order (this box calculates the available stock compared to recommended
display stock and gives a number for ordering)
When we enter the records it gets to a point where the item description
(which is stored and Item description ID but displays actual item
description) no longer appears on some records. The other dependant data
still works but this does not allow for the user to see that previous data
for item description and when exporting a report it also does not export this
info.
Any help would be greatly appreciated.
I seem to be having some difficulty with a continuous form that when you
enter new data the previous record will not show some data that was just
entered.
My database has 8 tables 7 tables are tables used by the form and one is the
feeder table from the form. The table is conceived to allow for an inventory
count using displays as the determining factor for what stock is actually
required.
The form is set up as follows:
Dealer number (Combo from one of the tables to insert a number to form)
Dealer Name (lookup box referring to the number just selected)
Report Date (simple entry field)
Fixture (Combo box allowing you to select from various fixtures in the store)
Hardware (Combo box allowing you to select specific hardware that would work
with the previously selected Fixture)
Category (Combo box allowing you to select from a group of predetermined
categories)
Item description (combo box that is dependant on the hardware selection
different hardware will give you different item descriptions)
Storage quantities, display quantities (these are simple data entry boxes)
Recommended stock (this box display an number associated with the Item
description record from the same table)
Order (this box calculates the available stock compared to recommended
display stock and gives a number for ordering)
When we enter the records it gets to a point where the item description
(which is stored and Item description ID but displays actual item
description) no longer appears on some records. The other dependant data
still works but this does not allow for the user to see that previous data
for item description and when exporting a report it also does not export this
info.
Any help would be greatly appreciated.