one form two tables linkages

[Guest]

I have two tables which require the input of numerical values into them. They
each have similar field headings but they are for seperate items, and so
parts and suppliers are different.
I have created two seperate input forms so i can input the numerical data
into the tables, but i was wanting to know if there was a way if using a
check box function i could have them linking into the apprioate tables. This
is because some of the values has to be placed into both tables and is to
save duplication of work.
Any suggestions as to how this can be done

 

[RBear3]

What are the fields in these tables? "parts" and "suppliers" are to very
different things. If your tables are normalized, I can't think of anything
that would end up in both tables.

Typically, you would have your parts in one table, and suppliers in a
separate table, then you'd have a third table that let you define which
suppliers prove which parts. This is a many-to-many relationship.

Give us more details and perhaps we can help you normalize your tables.

 

[Guest]

The tables are based upon the separate components need for the creation of
certain classes of aircraft. Since some components are generic to both
aircrafts i was wanting to create a form which would let me enter the value
into these fields which having to duplicate my work by going into each table
and inputting the information. I was also hoping that the same form could be
used to input the information if a check box was checked for just one class
of aircraft.