Search results

I have a simple report that displays a number of fields. I need to modify one date field: RMAReceiptDate and am unsure how to do this. When an item is received the date is entered in RMAReceiptDate. This date is properly displayed on the report. However, if an item has not been received...

I am trying to develop a form that allows me to enter shipment tracking info (Fed-EX # and ship date) into a SHIPMENT table, select the customer, contract, and delivery address via a dropdown from a CUSTOMER table, and select one or more serial numbers from a PRODUCTDATA table to create a...

I used Analyze Table to split a table into three tables Table2, Customer, and Shipment. Both the Customer and Shipment tables have an autonumber Primary Key (PK) field assigned (CustomerID & ShipmentID respectively). Table 2 is linked to these tables via Foreign Key (FK) fields CustomerID &...

I was provided a database (with inadequate limited data already dumped in by a predecessor) and told to make it work. The end goal is to include all product lines and their component details at the time of shipment to a customer. Currently, the database includes one table with 1200 records. Each...

I want to type information into a form and then when I save the record, the input data is used to pre-populate fields on the next record/form. Goal: The database captures shipping and configuration information for multiple systems going out to one location on the specified date and tracking...