Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Page Design Questions

0 views
Skip to first unread message

Adam

unread,
Jul 31, 2006, 2:04:03 PM7/31/06
to
I'm having some trouble getting a Page to work the way I want it to in
Access 2003. I'm trying to do some simple internal tracking at my
office for a specific item that we sell. Each item has a serial
number, so I created two tables. Here's the structure:

Table Name: T_ITEM
Primary Key: SERIAL_NUMBER
Other fileds: CLIENT_ID, DEPLOY_DATE, COMMENTS


Table Name: T_CLIENT_LIST
Primary Key: CLIENT_ID
Other fields: CLIENT_NAME


The CLIENT_ID fields are linked with a one-to-many relationship with
enforced integrity.


I'm fairly inexperienced in Access, so the controls on the pages I've
generated aren't working together :( Here's what I'm trying to
accomplish:


I would like a page that has a drop-down box from which you would pick
a serial number, and the relevant information (client name, deployment
date, comments) would appear in non-editable text boxes below.


I would also like to create a second page that has a drop-down list
containing all the client names, and directly below that a list box
that would populate with every item that had been sold to this, and
when you select an item in the list-box I would like the deployment
date and comments to appear in fields below that.


Since I will be hosting this on a web-acessible server, I only want
people to be able to view these pages and all the data, without being
able to edit records or create new ones.


Sounds pretty simple, but I have to admit I'm just not that good yet
:-P


(Thanks in advance for any help! I can provide the .mdb for reference)

0 new messages