Data not showing up in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that references a table with a bunch of data. Two fields are
Customer_ID and Company_Name. On the form you select the customer you want
by either one of these fields and then add in Trouble_Information. Whenever
we add a new trouble to the company the company name does not show up on the
table. The ID will show and all of the other corresponding information, but
not the Company_Name. What did I do wrong??
 
Should the company name show up there? Don't you already have company id
and name in a related table?

You should have two tables here. One with company data and one with trouble
data. In the trouble data table you would only store the company ID. The
company name, phone, address, etc. would all live in your company table.

This is the whole point of a relational database. You store data only once
in the appropriate tables, then you "relate" the tables to each other by
forming relationships using a common field.
 
how are you choosing customer on form? combo box? is the control table
correct and has all the fields you need?
 
Back
Top