table Issue

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

Hi,
I have a table that has a field that is a drivers id number anither that is
the drivers name it has the first and last name in.
It there is not two separtate fields.
the Drivers Id is a combo box that list both ID and name so the person can
find the driver that they need to calculate the payroll
the issue is that the name doesn't populate in the table it just shows blank.
So if i want to run a report it doesn't show that name
Note
I have the combo box set to use the Driversid so it will auto populate the
name
 
Hi,
I have a table that has a field that is a drivers id number anither that is
the drivers name it has the first and last name in.
It there is not two separtate fields.
the Drivers Id is a combo box that list both ID and name so the person can
find the driver that they need to calculate the payroll
the issue is that the name doesn't populate in the table it just shows blank.
So if i want to run a report it doesn't show that name
Note
I have the combo box set to use the Driversid so it will auto populate the
name
Click to expand...

If you're using the Lookup Wizard to put a combo box in a table...

DON'T.

See http://www.mvps.org/access/lookupfields.htm for a critique of what many of
us consider a misfeature.

Base your Report, not on the table, but on a Query joining the two tables.
Pick up the driver name from the table that it's in, and the other information
in the other table.
 
Thanks for the info
i didnt use the look up wizard for this. I just took the field and changed
it to a combobox and have the row source type set at Table/Query. Then the
row source is set at the driver's Id and name table. so it works great in the
form but it doesnt show the info in the table.

here is another ?
Is it best to separtate all data to smallest form. What I mean is to have
like driver's name table then Delay time table,truck numbers and so on.

thanks again
 
Somehow, the name is getting in the combo box by either referring to another
field or from a value list. Go into design mode and look at the
controlsource for the combo box.

Then open your table and post your table fields.

However, to get the report to work, design another query with the fields and
use that as your recordset to run the report.

HTH
 
Thanks for the info
i didnt use the look up wizard for this. I just took the field and changed
it to a combobox and have the row source type set at Table/Query. Then the
row source is set at the driver's Id and name table. so it works great in the
form but it doesnt show the info in the table.
Click to expand...

That's because a Form is one thing... and a table is another. The data is
stored in your table, and only in the table; the table upon which your form is
based contains the driver's ID - and not the driver's name (at any rate it
should NOT contain the driver's name, which should exist only in the table of
drivers).

The Combo Box on the form is *just a tool* to allow editing of the DriverID.
It does not contain the name; it *displays* the name.

If you want to see the name on a Report - again, create a Query joining hour
table (which I know nothing about, I confess) to the table containing ID's and
names, joining by the DriverID. Select the main table's information from the
fields in the main table, and the driver's name from the driver table.
here is another ?
Is it best to separtate all data to smallest form. What I mean is to have
like driver's name table then Delay time table,truck numbers and so on.
Click to expand...

Given that I have no way of knowing anything about the nature of the data
you're modeling, nor the existing structure of your database, there's no way I
could comment, other than the standard advice "Identify all of the Entities
relevant to your application, and create a table for each type of Entitiy".
See the tutorials at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top