A
adam.j.tucker
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
(Thanks in advance for any help! I can provide the .mdb for reference)
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 toaccomplish:
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
(Thanks in advance for any help! I can provide the .mdb for reference)