Entering in Forms Should Populate Table

[Vylent Fyre]

Hi all,

I know this is very simple for a lot of you and I apologize right up front
for appearing to be an idiot...

I have a Form named "frm_Divisional New One Off JE's" that should be feeding
into a table "tbl_One Off JE's". This is a data entry form whereas
everything that is typed into this form should be in this table.

I have a subform inside this form named "sfrm_One Off JE's" inside the
"frm_Divisional New One Off JE's". This subform could be 10 lines, etc.

My problem is - On the top part of the form I have the "Year/Pd" where the
user enters the date (akin to June 2008) for a Batch # and JE #. The subform
for this could be 5 lines long. In the table, I will see one line for June
2008, and the other lines will have nothing in the Year/Pd field for the JE
#.

Is there a way that for each line with the JE # it will tie to the Year/PD
as well?

Here's an example of what's in the table currently with just a test done -


Division Month & Year Batch # JE # Rcrd by/Date Appr by/Date Posted
by/Date Co Fut Loc LOB Unit Acct Sub SubA Debit Credit Description
010 6/1/2008 112233 445566 $0.00 $0.00
010 112233 445566 010 0000 001 100 000000 6045 001 001 $0.00 $5,000.00 TESTING LINE
010 112233 445566 010 0000 001 100 000000 6045 001 001 $5,000.00 $0.00 TESTING LINE 2

 

[Beetle]

It would appear that the problem is with your table structure. I can't really
determine anything about your data, but let's say for the sake of argument
that a Batch No. can have one or many JE numbers. Then the JE numbers
(along with any data related specifically to a JE number) would belong
in a separate, related table. Then the main form would be based on
the first table with the subform based on the second table.

Here are some links where you can find good information about
proper relational database design.

http://allenbrowne.com/casu-22.html

http://www.mvps.org/access/

http://www.accessmvp.com/JConrad/accessjunkie.html