sparklegrrl
Registered User.
- Local time
- Today, 17:04
- Joined
- Jul 10, 2003
- Messages
- 124
I am so new to Access and learning so much but this one VERY SIMPLE little thing is making me nuts!
I have a table WORKORDERS set up in my database. For example it has:
WORKORDERS
WORKORDERID (primary key)
CUSTOMERID
PURCHASEORDERNO
CARINITIALID
CARNUMBER
Some of these values (IE: CUSTOMERID, CARINITIALID) pull from other tables such as
CARINITIALS
CARINITIALID (primarykey)
CAR INITIAL
I have the WORK ORDERS table set up so that it stores the Customer ID and the Car Initial ID as their PK# as opposed to the value. I was told to set it up that way as part of normalization.
The problem is that if I go to create a form for example SHIPPING
and I create a drop down box with the work orders listed and tell it to select a record on the form based on the value in the box the value displays as the primary key instead of the data.
For example....
Work order: 1
Car Initial: 3
Car Number: 123456
Instead of
Work Order: 1
Car Initial: GATX
Car Number: 123456
I know this is probally a simple setting in the car initial field on the form but I can't figure it out and it's making me nuts.
Do I have to create a query for this so it will display properly? I can't I just pull the data from the table & tell it to display as the text as opposed to the primary key number?
I have a table WORKORDERS set up in my database. For example it has:
WORKORDERS
WORKORDERID (primary key)
CUSTOMERID
PURCHASEORDERNO
CARINITIALID
CARNUMBER
Some of these values (IE: CUSTOMERID, CARINITIALID) pull from other tables such as
CARINITIALS
CARINITIALID (primarykey)
CAR INITIAL
I have the WORK ORDERS table set up so that it stores the Customer ID and the Car Initial ID as their PK# as opposed to the value. I was told to set it up that way as part of normalization.
The problem is that if I go to create a form for example SHIPPING
and I create a drop down box with the work orders listed and tell it to select a record on the form based on the value in the box the value displays as the primary key instead of the data.
For example....
Work order: 1
Car Initial: 3
Car Number: 123456
Instead of
Work Order: 1
Car Initial: GATX
Car Number: 123456
I know this is probally a simple setting in the car initial field on the form but I can't figure it out and it's making me nuts.
Do I have to create a query for this so it will display properly? I can't I just pull the data from the table & tell it to display as the text as opposed to the primary key number?