Search results

  1. S

    Table Structure / Setup

    sure! Basically a job will have multiple bids from different companies, these bids are based on the square footage of the project, which is why i have the SQFT related to the job. I then am taking this collection of bids and entering it into the database, per job. Then I'm just trying to...
  2. S

    Table Structure / Setup

    Thanks for the advice ! after working through this tutorial, I came up with this result.. I'm least confident about the SQFT bring in the jobs table, but it would be unique per job, but then I end up having two foreign keys related to the SQFT/Bid table. I feel a lot more on the right track though.
  3. S

    Table Structure / Setup

    I'm actually trying to move this data over from a spreadsheet.. so that would make perfect sense haha. Ill give that a read and see what I can accomplish. Thanks
  4. S

    Table Structure / Setup

    Hello All, New to access so sorry in advance :) hopefully i explained my thoughts adequately. ID | JOB_NAME | JOB_DATE | TYPE | SIZE | etc... 1 2 Currently, each job has the information entered here, with just basic information about the job entered. Then there is another form which has...
Top Bottom