User Profile

Collapse

Profile Sidebar

Collapse
Chips
Chips
Last Activity: Aug 25 '06, 03:50 AM
Joined: Aug 24 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Chips
    replied to Working around not being able to update a union
    in Access
    Thanks mmccarthy

    Will have to come up with another plan ... more than likely it will involve changing the entire structure and normalising the tables.

    Chris
    See more | Go to post

      Leave a comment:

    • Chips
      replied to Working around not being able to update a union
      in Access
      Unfortunately the table has been set up this way from then beginning (a number of years ago), and has loads of data already in it, plus there are many other parts of the database which now rely on this. Therefore I am reluctant to change it as it would mean huge structural changes.

      If it is going to be an ongoing issue I might have to look into doing a big redesign?!?

      Thanks,

      Chris
      See more | Go to post

        Leave a comment:

      • Chips
        started a topic Working around not being able to update a union
        in Access

        Working around not being able to update a union

        Hi, I am trying to create a form which displays fuel uplifts for different flights, they are then reconciled against invoices and therefore need to be updated (invoice numbers added).

        All flights and their associated details are kept in a table ‘tblFlights’, there are fields for each uplift (maximum of three). A simplistic example is below…

        FlightID FuelUplift1 InvoiceNo1 FuelUplift2 InvoiceNo2 FuelUplif3 InvoiceNo3...
        See more | Go to post
        No activity results to display
        Show More
        Working...