O
oncewaswillow
I am creating a database for equipment hire. There is a table for equipment
type(type,deposit,hireage) and a table for stock
(type,stocknumber,availability). There are no more than 10 stocknumbers of
each type. I wish to create a (continuous?)form that will list the type down
the form and show the available and unavailable stocknumbers across the form.
Each stocknumber would work as a button to open another form (this part I can
do).
eg
TYPE AVAIL OUT
Crutches C1 C3 C2
What would be the best approach?
type(type,deposit,hireage) and a table for stock
(type,stocknumber,availability). There are no more than 10 stocknumbers of
each type. I wish to create a (continuous?)form that will list the type down
the form and show the available and unavailable stocknumbers across the form.
Each stocknumber would work as a button to open another form (this part I can
do).
eg
TYPE AVAIL OUT
Crutches C1 C3 C2
What would be the best approach?