subform and connecting fields

G

Guest

Hello, I'm trying to find out what's the best way to approach developing this
database.

I'm trying to develop a database that has data in it already that's there as
a description for selection and in addition would have additional data
entered in it by the entry person. The entry person would be selecting
choices and then in some instances select a choice and then also enter data
in another field that goes along with that line item. There are at least 15
groups of data with 15 to 30 line items to choose from per group and the user
could be selecting data from all of the groups or just one group with only
selecting one or several line items from each group or just one.

What approach I so far looked at is to create a form using two tables. The
main form has the key and ID information of the main record that references
one table. Then I would like to have several subforms that are actually
referencing the the other table. These subforms would be representing the
different groups and also would be on the main form and seperated in a tab
view. So the user can select which subform or multiple subforms to enter data
for that record. Also on those subforms the fields need to be connected by
line item. Meaning that the first field is a radio button with a yes/no value
and the next field that's somehow connected to the radio button has a
description in it and then sometimes there would be a third field on that
line that would be a text field that the user would enter data in it. The
radio button is for a filter that would be used in a report to only print
those items that where selected and omit all other items that were not
selected.

If I'm on the right track how would I actually connect the line items and
how do I make the subforms unique and finally how do approach this in the
report.

If I'm not on the right track what would be the best way to approach this?
 
J

jahoobob via AccessMonster.com

Let's see if we can sort this out.
You've got a description (field) and you want to be able to associate
multiple data (fields) with this description. Some of these fields you want
to associate would be things like yes or no or choice a,b,c, d, etc. and some
would be things like entering a date or a name or a value, etc.
1.) Add the fields to the current table. The ones that are Yes/No select
Yes/No as the data type. The ones that will be entered from a list of
choices set the data type as Number and the Field size as Short Integer
2.) Create tables for all of the values where the person is going to be
choosing from a list and enter those choices along with an ID number
(autonumber) primary key.
3.) In your data entry form use combo boxes based on these tables (use the
wizard to create them) and when asked tell Access to use the ID column as the
data to store.
If you post a little more specific information it will be easier to give you
more specific help.
Bob
 
G

Guest

I hope I can explain things better.

The form starts with an ID Number and Name.
Then,
the Group fields have a yes/no field and a group description field.

The line item fields include a yes/no field, description field that would
have data in it already, text field that would be filled in by the user.

The default value for the yes/no field would be no.
The user would only select yes if they were going to use the description
that's already listed in the field, and if need be enter any data in the text
field, if that line item has the option of any entry. Not all line item will
have an entry text field.

Now to explain the entry process.
The entry person would first enter an ID number and name.
Then they would select a group and then select one or several line items in
that group and if so also select other groups and line items in those groups.
The last part of entry is a comment field for the entry person to add any
comments.

The report would be the ID and name followed by the group description(s)
that were selected and the line items that were selected. For instance;

ID - NAME
GROUP1 DESCRIPTION
LINE ITEMS DESCRIPTION and TEXT ENTRY
GROUP2 DESCRIPTION
LINE ITEMS DESCRIPTION and TEXT ENTRY
GROUP3 DESCRIPTION
LINE ITEMS DESCRIPTION and TEXT ENTRY
COMMENTS

I hope this clearifies it better. All help is greatly appreciated !
Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top