S
so_unq
Hi, i am currently developing a data access page for our sales database which can be accessed within our organisation and from outside using the web browser to make necessary queries.
I have created the access database and used the wizard to design the data access pages but i can only scroll from one record to another either in ascending or descending order.
I'd like to be able to access a particular kind of item model or use a description to view or change data.
I have three tables; the description table lists the items with their serial nos and other info; this has a relationship with the quantity table for the year which is also related to the financial table which takes care of the transactions.
How can i design the data access page so that i can select on a drop down menu the particular item description say speakers and for further filtering click on a particular model to access necessary information to view or update.
Thanks for your assistance.
I have created the access database and used the wizard to design the data access pages but i can only scroll from one record to another either in ascending or descending order.
I'd like to be able to access a particular kind of item model or use a description to view or change data.
I have three tables; the description table lists the items with their serial nos and other info; this has a relationship with the quantity table for the year which is also related to the financial table which takes care of the transactions.
How can i design the data access page so that i can select on a drop down menu the particular item description say speakers and for further filtering click on a particular model to access necessary information to view or update.
Thanks for your assistance.