Recent content by PuzzledNH

  1. P

    Display alternate text if date is blank

    This was the solution, Thank you. The ([RMAReceiptDate] field is a "short date" data type field which I was directly using in the report. I deleted the ([RMAReceiptDate] field from the report, inserted a new text box, changed the control source of the new text box to reference NZ...
  2. P

    Display alternate text if date is blank

    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...
  3. P

    Table Design & Relationships

    Hi Pat, A copy of the test database is attached. I have one form Form-60cm Dish that users are currently using to input or scan data into the database. Each new product line will have a similar data entry form. (FormShipment and associated subform are being experimented with and not fully...
  4. P

    Table Design & Relationships

    I am still working to break down tblProductData One idea I am poking at is based on the fact that each part number collects a maximum of 10 possible bits of data that would need to be retained. Each part number "may" contain one or more (but not all) of the following common data items to...
  5. P

    Combo Box works for New Records but not for Record Updates

    So I deleted the form and recreated it. The combo box is working as expected now. I am not sure what the issue was. However, everything is good. Perhaps some erroneous artifact was causing the issue and was cleared when the form was deleted. Thank you for the assistance. Issue is closed.
  6. P

    Combo Box works for New Records but not for Record Updates

    Not that I am aware of. But, I am not very familiar with visual Basic. When I open the VB macro the only code I see is as follows: Option Compare Database Private Sub Product Line_AfterUpdate() Me.[Product Line].DefaultValue = """" & Me.[Product Line].Value & """" End Sub I suspect this was...
  7. P

    Table Design & Relationships

    I have made some progress on table structure and have broken the original table1 into 4 tables: tblCustomer Customer, Contract, Delivery Order, DeliveryLocation, and fields for old contact info that are not used and will eventually be deleted. (Approx. 100 records and 14 columns. Half the...
  8. P

    Combo Box works for New Records but not for Record Updates

    Hi theDBguy, Control Source: CustID Row Source: SELECT [Customer].[CustID], [Customer].[Customer], [Customer].[Contract], [Customer].[DeliveryOrder], [Customer].[CLIN], [Customer].[DeliveryLocation] FROM tblCustomer; Row Source Type: Table/Query Thank you.
  9. P

    Combo Box works for New Records but not for Record Updates

    Hi Pat, Based on plog and your input, I redid the relationships and re-labeled the relationship pairs to be the same. See the attachment for the new relationships table. Thank you. I am still working/struggling on column names and will repost in my prior thread on the Tables forum. Again, I...
  10. P

    Combo Box works for New Records but not for Record Updates

    Hi plog, Not intentional. Just my ignorance showing through.I havent worked on a database since I took a class 10 years ago. I am definately here to learn and am just struggling with how to break down the data tables. I did listen. :) I wanted to verify the data did not get distorted during...
  11. P

    Combo Box works for New Records but not for Record Updates

    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...
  12. P

    Foreign Key shows data rather than Key reference

    So in this case the SELECT code is just displaying the info in the referenced table's fields? Thank you.
  13. P

    Foreign Key shows data rather than Key reference

    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 &...
  14. P

    Table Design & Relationships

    I tried to use the Database Tools - Analyze Table and split Table1 into two tables to separate Customer info from the remainder of the data. I ended up with a Query called Table1 and Two Tables Customer and Table2. Table1 was renamed Table1_OLD. The Customer table is linked via ID (PK) to...
  15. P

    Table Design & Relationships

    Hi Mike, This doesn't make sense to me. If I delete all the PRS11 fields in TablePRS11Data what am I associating PRS11ID to? What fields should be in TablePRS11Data (and in the other tables)? I am still struggling with what the structure should be. I.e. How many tables, what fields should be...
Top Bottom