letters not numbers in table


H

Humbled Learner

Good day

I have a simple database

1 table Customers, with name, address and phone
1 table with shipper 1fedex, 2ups (for drop down box for a form)
1 table with items 1 box, 2 envelope, 3 package (for dropdown box for a form)
1 table New Order, with Customer ID, Shipper, Item, and date.

When I use the report with the drop down boxes everything works fine but...
autodate, fedex, box and customer name... but...

When I open the New Order Table again, instead of showing the name of the
customerid, it shows the number of the customerID.

Same with the shipper and item, it will show "1" instead of fedex or "2"
instead of envelope.

Is this a simple fix?


Thank You for your time.
 
Ad

Advertisements

K

KARL DEWEY

Stay out of the tables!
Always use queries, forms, and reports to interface with the data.
Always use queries to interface with the forms, and reports.
In your queries just join to the tables that have the text on the IDs -
Shippers and Items.
 
Ad

Advertisements

J

John W. Vinson

Good day

I have a simple database

1 table Customers, with name, address and phone
1 table with shipper 1fedex, 2ups (for drop down box for a form)
1 table with items 1 box, 2 envelope, 3 package (for dropdown box for a form)
1 table New Order, with Customer ID, Shipper, Item, and date.

When I use the report with the drop down boxes everything works fine but...
autodate, fedex, box and customer name... but...

When I open the New Order Table again, instead of showing the name of the
customerid, it shows the number of the customerID.

Same with the shipper and item, it will show "1" instead of fedex or "2"
instead of envelope.

Is this a simple fix?


Thank You for your time.

It's showing the number because the number is what's stored in the table. This
is expected and correct behavior.

Tables belong "under the hood", out of sight; if you want to edit and interact
with data, use a Form based on the table, with (say) a combo box on the form
for the shipper. This combo box will DISPLAY "FedEx" while actually STORING 1.

You can base Reports on queries joining the New Order table to the other three
tables so that you can store the numeric ID's in the New Order table while
displaying the text on your report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top