Hi all,
I've attached the database I'm currently working on.
What I need to create is a user friendly form to input f_quantity values.
The main form needs to have a parameter where a customer ID would be selected.
I then need what I think would be a datasheet subform which would display all the p_codes down the left hand side, the m_id in the order 1,2,3 etc. across the top with the f_quantity as the data.
I'm guessing I'm asking if anyone know if this is possible or not? If so, could anyone give me some advice on how to create the form/subform?
Many thanks in advance,
Nick
I've attached the database I'm currently working on.
What I need to create is a user friendly form to input f_quantity values.
The main form needs to have a parameter where a customer ID would be selected.
I then need what I think would be a datasheet subform which would display all the p_codes down the left hand side, the m_id in the order 1,2,3 etc. across the top with the f_quantity as the data.
I'm guessing I'm asking if anyone know if this is possible or not? If so, could anyone give me some advice on how to create the form/subform?
Many thanks in advance,
Nick