Utilizing data between tables

[Ben]

Hi there,

I have a table (let's call it "table 1" with all general employee
information, including name, employee number, etc. The employee numbers are
unique per person and I'm thinking I want to use that as the unique
identifier between tables.

I'm trying to set up a "Timesheet" table, which will allow someone to select
any employee listed in "table 1", via combo box, and store it into fields of
table 2, indexed by employee ID.

I'm fairly new to Access and am running into a knowledge gap into how to
adequately do this. Any help would be appreciated.

Thanks

 

[tina]

first of all, the tblTimesheet should *not* store any employee data EXCEPT
the primary key (unique identifier) from Table1 (in tblTimesheet, that field
is known as a foreign key). don't include employee name, etc - that data is
already stored in Table1, and shouldn't be duplicated in any other table.
make sure you link the two tables, from the primary key field of Table1, to
the foreign key field of tblTimesheet, in the Relationships window, and
enforce referential integrity.

second, don't do your data entry in tables - tables are for *storing* data
only. create a form, bound to tblTimesheet. use a combobox control - bound
to the foreign key field, and with its' RowSource set to Table1 - for
entering the employee for each record.

and last, suggest you read up/more on relational design principles, and read
up on combobox controls, in Access Help.

hth

 

[John W. Vinson]

Hi there,

I have a table (let's call it "table 1" with all general employee
information, including name, employee number, etc. The employee numbers are
unique per person and I'm thinking I want to use that as the unique
identifier between tables.

I'm trying to set up a "Timesheet" table, which will allow someone to select
any employee listed in "table 1", via combo box, and store it into fields of
table 2, indexed by employee ID.

I'm fairly new to Access and am running into a knowledge gap into how to
adequately do this. Any help would be appreciated.

Thanks

Follow Tina's as-always excellent advice; you may also want to look at some of
the tutorials and other resources here:

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

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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

 

[tina]

thanks for stepping in with the valuable references, John - i left the op
pretty well hanging out in space on that one!