Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Database Query

  • 14-12-2005 9:35am
    #1
    Chada
    Closed Accounts Posts: 408 ✭✭


    Hey,

    relatively simple question although i can't seem to get an answer on google:

    If i create a database with Microsoft Access can i open it with filemaker pro and vice versa?

    Im a 3rd year of Software engineering, and I did all my post-uni database work on Filemaker pro. Now i have been asked to create an entire database in Access 2000.

    I have the fundamentals down, but i'm having trouble with getting the relationship to copy over all the data of my primary key to another table. I have been through numerous database tutorials and taught myself SQL to get this done, and now im feeling very frustrated as its probably something really easy.

    Basically, I have the relationship for my primary key set one-to-one and all the primary key data has been entered, yet it doesnt seem to want to copy over to the other table.

    Sorry if this is pathetically easy but i've other work i need done and this is becoming a pain in the behind :) (This isnt coursework btw im on placement)

    Thanks in advance for any help,

    daN


Comments

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Are you talking about a foreign key? Sounds like you are.

    I don't think it makes sense to automatically copy all primay key data over from one table to another based on the primary key alone.

    Give us some more info on what you are doing and we will see what we can do.


  • #3
    Chada
    Closed Accounts Posts: 408 ✭✭Chada


    Pretty much i've created a table of building names and details to do with fire lectures and im trying to weed out the lectures which are upcoming, overdue, cancelled.
    I've wrote the SQL for the queries however, i seperated the data fields into 4 tables building details, overdues, cancellations and lectures (where all the dates are held). I'm basically tring to copy over the facility name as its a primary key from the building details tale to the lectures table.

    This process is done in filemaker pro with entities however i have no experience with access and i am starting to regret using it.

    Any help much appreciated,

    A very confuddled daN.


  • #4
    The_Thing
    Registered Users, Registered Users 2 Posts: 1,017 ✭✭✭The_Thing


    www.access-programmers.co.uk are your friends, and if you ever need help with Excel try www.mrexcel.com


  • #5
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Chada wrote:
    I'm basically tring to copy over the facility name as its a primary key from the building details tale to the lectures table.

    So, something like

    INSERT INTO LECTURES (SELECT FACILITY_NAME FROM BUILDING_DETAILS)

    I don't have Access in front of me right now, so I can't test this.

    Worst case scenario, do an export from Building Details and import it into Lectures (only select the primary key to be exported).
    Chada wrote:
    This process is done in filemaker pro with entities however i have no experience with access and i am starting to regret using it.

    I have no experience in Fimemaker, but the theory behind them should be the same.


Advertisement