I am trying to use a main form and a sub form to enter data into 2 related tables.
The main table has the fields:
Date:
Line:
Shift:
The child table which has the following fields:
Date:
Line:
Shift:
Downtime Hours:
Reason Code:
For every 1 record in the main table, there could be multiple...
I have a table where a "StartDate" and "EndDate" field is entered for each record. I would like to ensure that the "EndDate" entered is always greater that the "StartDate". Both fields are in a general date format.
Thank you.
I am looking at this from the perspective of data entry into a table or form.
An example would be where you have an Item Master table with an Item # and Item Description Field. This table is fully populated with all items and descriptions.
In a second table, the user is keying in the item #...
I am looking at this from the perspective of data entry into a table or form.
An example would be where you have an Item Master table with an Item # and Item Description Field. This table is fully populated with all items and descriptions.
In a second table, the user is keying in the item #...
Assuming the folling tables and field names
Table Name = "Lot"
Field 1 = LotNumber
Field 2 = Weight
Primary Key is Field 1 "LotNumber"
This table is populated with lot numbers and weights.
Table Name = "LotEntry"
Field 1 = LotNumber
Field 2 = Weight
This is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.