Need help with form (datasheet view)

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a one-to-many relationship between "Organizations" and "Projects".

The fields that further describe the organizations are stored on a main
form. Then I have a subform (datasheet view) that holds information about
its subordinate projects.

For data entry, I use a combo box on the subform from which the user can
select the projects that are subordinate to an organization. The projects'
information (for the combo) is pulled from a relatively static table e.g.
called "tblSourceData". The actual records are then stored in a table
called e.g. "tblStorageData".

When entering a new record, the subordinate projects for a specific
organization are all listed in the "datasheet" view.

However, I simply don't want to list the entire subset of projects for the
selected organization. However, I do want the entire subset of projects
listed in the combo box. I don't want "hard code them" into the combo's
row source though.

Does anyone have a recommendation to dynamically pull the row source from
the tblSourceData but not show all of the project values in the datasheet
view. I only want to see those records that actually have been selected
from the combo box and are stored in the tblStorageData. Does that make
sense?
 
Records (and therefore fields) are stored in tables.
Forms are a good way to view and manage the information.
When you refer to storing data in a form, can I take it to
mean the form's underlying table?
What I am not following here is the data entry. As I
understand, you want to select a value from a combo box
and have other fields populated according to the selected
value. If so, try the combo box wizard for showing a
record based on the selected value. See Help for more
details. If there is other field-by-field data entry
beyond the selection, that can occur in addition to the
fields populated by the combo box selection.
Of some possible concern is storing values from one table
in another table. If you are using a table as a row
source for a combo box for to populate a single field or
related fields, that is OK. Here we use a table for
manual number, revision, and date. All of the values are
stored in another table, since we need to know the
revision and date at the time of the repair. On the other
hand, with records from an Employee table you would
probably establish a relationship with the primary key.
If the employee's name changed last year, records for that
employee from two years ago should probably show the
current name, not the old one.
The question here is whether you want to store in
tblStorageData the current values that are in
tblSourceData, or if you want old records to reflect
updated values. If the latter, you need to link to a
primary key in tblSourceData rather than storing the
current values. If this is too vague, more details about
table structure would help in providing a more specific
answer.
-----Original Message-----
I have a one-to-many relationship between "Organizations" and "Projects".

The fields that further describe the organizations are stored on a main
form. Then I have a subform (datasheet view) that holds information about
its subordinate projects.

For data entry, I use a combo box on the subform from which the user can
select the projects that are subordinate to an organization. The projects'
information (for the combo) is pulled from a relatively static table e.g.
called "tblSourceData". The actual records are then stored in a table
called e.g. "tblStorageData".

When entering a new record, the subordinate projects for a specific
organization are all listed in the "datasheet" view.

However, I simply don't want to list the entire subset of projects for the
selected organization. However, I do want the entire subset of projects
listed in the combo box. I don't want "hard code them" into the combo's
row source though.

Does anyone have a recommendation to dynamically pull the row source from
the tblSourceData but not show all of the project values in the datasheet
view. I only want to see those records that actually have been selected
from the combo box and are stored in the
Click to expand...
tblStorageData. Does that make
 
Bruce:

Thanks for sharing this w/ me. Not sure if I completely follow your
guidance though.

Would it be possible if I email you a sample database. In additionn, I'd
forward you more information as well. I believe though, viewing the actual
db would help the most in this dialog.

Thanks,
Tom
 
I will have to get back to you from my home computer. I
have Access 97 there, so if you send something that is in
a later version of Access you will need to go to Tools >
Database Utilities > Convert > Prior Version. Do this
from a copy of the DB.
In the meantime, let me ask if the form is based on either
a table or a query? In either case the data is stored in
the table; the query is just an intermediary. In no case
is data stored in a form, although it may be held there
while the form is open.
 
Back
Top