W
Wingnut
Our laboratory uses Access to track test results. I am trying to eliminate
some of the steps we go thru each time we enter new data by configuring
Access to populate some specific fields.
I have 2 tables I'm trying to work with. The first table (tblUPCs) contains
a UPC number which is associated to a bunch of other information including a
field that contains the number of days from the production date until the
expiration.
The second table (tblMain) has all the other information that must be
manually entered. What I would like to do is create an expression for the
Default Value in this table which will take the number of days corresponding
to the UPC we scan in and then add that number to the current date.
I'm fairly new to access so I'm open to making some changes to the structure
of the database. I'm fairly confident that my structure is fine I'm just
lacking in the ability to program. I've read some of the previous responses
to similar questions and I don't feel like they help in this circumstance.
They weren't trying to pull data from a field in an associated table.
some of the steps we go thru each time we enter new data by configuring
Access to populate some specific fields.
I have 2 tables I'm trying to work with. The first table (tblUPCs) contains
a UPC number which is associated to a bunch of other information including a
field that contains the number of days from the production date until the
expiration.
The second table (tblMain) has all the other information that must be
manually entered. What I would like to do is create an expression for the
Default Value in this table which will take the number of days corresponding
to the UPC we scan in and then add that number to the current date.
I'm fairly new to access so I'm open to making some changes to the structure
of the database. I'm fairly confident that my structure is fine I'm just
lacking in the ability to program. I've read some of the previous responses
to similar questions and I don't feel like they help in this circumstance.
They weren't trying to pull data from a field in an associated table.