one form to populate two tables

  • Thread starter Thread starter jfd111
  • Start date Start date
J

jfd111

Hi Everyone,

I am new to Access and am learning a lot but I've a question. We get
equipment in here to evaluate and repair all the time. In my DB I want to be
able to enter data on my RA form, have it update the RA table (which it does)
but also populate certain feilds on a second table called Eval table. This is
so when the Eval report is run some of the feilds are filled out already. We
always have to fill out an RA but we fill out the Eval form only
whenevaluating equipment for repair.
Hope this makes sense. Any help will be greatly appreciated!
 
John

If you have two tables that contain some of the same values/fields, you have
.... a spreadsheet!

In a well-normalized relational database, the only field you find in common
between (among) tables is a shared key.

It would help us help you if you provided a bit more detail on the current
structure of your tables.

Here's a (grossly-oversimplified) example of a table structure for a
Registration database:

tblPerson
PersonID
FName
LName

tblClass
ClassID
ClassTitle
ClassDescription

trelRegistration
RegistrationID
PersonID
ClassID
RegistrationDate

Please post your table structure.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Hi John,

In general, you only want to store similar data in two tables when you need
to maintain a history. Two examples include:

1.) The current selling price for a product versus the price at the time of
sale
2.) A person's address that an order was shipped to versus their current
address

If this does not describe your situation, then you have a database
normalization issue that you should look into. The reason is that if the
values are not the same for a given record, which value is the correct one?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Back
Top