Help in Linking Tables

[xsubzeroz]

I created table named "A" that contains:

FIELD NAME DATA TYPE
Date Date/Time
Length Number
Width Number
Height Number

I would like to create another table "B" that will have FIELD NAME linked to "A" and number will be different.
I've created Form that will have "Date" Text Box to show date same for both table since it's linked. Then I'll have Labels "Length" "Width" "Height" and two colums to show numbers from table "A" & "B". My question is how to create table "B" to have FIELD NAME same as in table "A" (Linked) Thanks for going over my question.

 

[xsubzeroz]

Sorry I forgot to mention that under FIELD NAME "Date" is my primary key.

 

[RoyVidar]

Not sure I understand your question, but before you start creating more tables do one thing:

Rename the fields so they don't have names equaling reserved words in access. The most critical one is Date. Rename it EnterDate, SubmitDate or whatever, as long as it doesn't equal "Date"

Roy-Vidar

 

[Chavito21]

Are both tables going to have the same information???
Why would you like to do that? Are both tables on the same database?

 

[xsubzeroz]

Thanks for your response. The only reason why I'm creating two tables is because I'm trying to collect data for scrap on my line. There are two parts involved so I would like each day to enter "date" and then enter in two text boxes number of scrap for each part. So it's going to have same date but different numbers.