SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict lveale's Avatar
    Join Date
    Jun 2001
    Location
    Dublin
    Posts
    221
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with MS Access Forms

    Hi,
    I need to do a quick and dirty proof of concept using Ms Access (Needs to be done yesterday!!!! ARRRGHH) on a clients network to show them how *EASY* it is.

    The database design is done, no problems there at least in theory!

    I have two tables:

    The first, DETAILS_TBL: PID (The Primary Key), Name, Address and other personal details.

    The second, QUALS_TBL: QID, qualification, date of qualification, PID (Foreign key going back to the first table, DETAILS_TBL).

    I want two forms; the first for personal details, and second for qualifications.

    I've linked from the first form to the second using the Form Wizard but the qualifications don't pick up the PID even though I've defined a realtionship between the two.

    Can anyone with Access experience point me in the right direction?

    I've tried messing around with the Datasource/Rowsource but to no avail!

    Thanks

  2. #2
    SitePoint Evangelist azizur_rahman's Avatar
    Join Date
    Nov 2001
    Location
    London, UK
    Posts
    502
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You'll need to make a sub form which is a DataSheet Layout.. then put this in/on to the form for DETAILS_TBL.

    you'd probably have to mke a query for the data there...
    Azizur Rahman
    Web Application Developer


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •