Search results

  1. V

    Cascading Combo Boxes (VBA coding)

    Okay I need some help with cascading combo boxes. See below: Master Site Table: Site ID (Investigational Site), Investigational Site, Mailing Address, Mailing Address 2, Mailing Address 3,Mailing Address 4, Mailing Address 5, Mailing City, Mailing State, Mailing, Zip Code, Mailing Country...
  2. V

    Primary and Foreign Keys

    I am trying to work on a database and now I am getting completely confused and need some help. Can someone explain to me how primary and foreign keys work? Here is a basic structure of what I am planning. Table 1 Site ID Site Name Site Address (broken up of course) Table 2 Personnel ID...
  3. V

    Verifying Data exists in DB

    I need some help. table 1 - site name and info table 2 - site personnel info (each site can have more than one personnel so it is tied to table 1 with an ID) table 3 - phone contact details (in the form, everything fills out automatically for the site info but i need to be able to enter the...
  4. V

    Combining 2 Reports

    I need to combine 2 reports into one Master Report. Instead of making one huge table with all the information, the data was split into 2 tables. They now want a report that prints all the information out on one page. Here is my issue: Report 1 (master data) - asks for a parameter Report 2...
  5. V

    Pre-fill column in Table with Query outcome

    I have a Master Data Table and a Payments Table. I have a query that uses the relationship between the two to get the Total Payment (each specific entry in the Master Table will potentially have several payments so I made this query so we could keep track of what was paid so we can compare it...
Back
Top Bottom