Removing fields from table

[Teri]

I have two tables (DHR Table 1 and Shipping). The DHR Table 1 holds testing
information on CUSB, Box12Z, ISOTR, and PCC16L. Besides the testing
information, there is a field to hold the seriel number for each of the
aforementioned items. The shipping table, of course, holds shipping
information (which I need to break down to another table as well, but need to
work on one problem at a time, so will worry about that one later). The
shipping table also has fields for the seriel numbers mentioned previously.
I need to remove the fields from one of the tables, but still have them come
together in reports. I also need to be able to update them both with the
mentioned seriel numbers. Which table should I remove them from so that I am
not duplicating information? The shipping table does not always have the
seriel number fields filled in, due to the fact that not all customers are
puchasing those items. Do I need to break it down further and have yet
another table for just the seriel numbers? I am really confused on this and
have been working on the database a long time.

Thanks,

Teri.

 

[Teri]

I forgot to mention that the seriel numbers may be repeated in either table
for a variety of reasons.

Thanks again!

Teri.

 

[Jeff Boyce]

Teri

I don't have a very clear picture of your table structure.

Remember that if you want to be able to join tables, they have to have at
least one field in common.

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

 

[Teri]

Jeff,

Thanks for taking the time to review my posting! Sorry I wasn't clear, I
saw what you meant after I read your post and went back to review my own.
This is the first database that I have ever created, and I have been teaching
myself how to use Access. But I think I have answered my own question. I
cannot delete these fields from either one of these tables because they
should not even be in the same database. Although both tables would include
information regarding the equipment, there would not necessarily be a
shipping record to create for each piece of equipment which is tested. My
worry now should only be breaking down the shipping table so that it make
sense.

Thank you again for taking the time to review my post, I really appreciate it.

Teri.